Skip to main content Skip to complementary content

Fmod

fmod() is a modulo function that returns the remainder part of the division of the first argument (the dividend) by the second argument (the divisor). The result is a real number. Both arguments are interpreted as real numbers, that is, they do not have to be integers.

Syntax:  

fmod(a, b)

Return data type: numeric

Examples and results:  

  • fmod( 7,2 ): returns 1
  • fmod( 7.5,2 ): returns 1.5
  • fmod( 9,3 ): returns 0
  • fmod( -4,3 ): returns -1
  • fmod( 4,-3 ): returns 1
  • fmod( -4,-3 ): returns -1

Learn more

 

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com