Fuctionality of mod()

[raghvendrasingh]

Hi All,

1.what is process of mod() function in qlikview,if we give the mod(-5,3) then it returns 1,but in general mathematics it gives -2,

2.why mod(3,-2) gives NULL

please anyone give the clarification about mod() function.

Regards,

Raghvendra

[#2]

QlikView mod function works only with integers.

To get the right output of ur examples use fmod function.

Like fmod(-5,3) and fmod(3,-2)

Hope this will give u required output.

[vipin_mishra479]

Hi Raghvendra,

mod(x1 , x2)

Mathematical modula function. Both parameters must have integer values. x2 must be greater than 0. The result is the non-negative remainder of an integer division.

regards,

vipin

[raghvendrasingh]

hi fiends,

i want the programmig logic of mod() function.not the features.how it internally works..