Division Command

[#1]

Hello,

i want to make a division like % in sql commands

suppose i want to have : 9/4 = (2,1)

what shoul i replace "sum( [Wit Quantity Second Unit] / [Factor] )" with?

Regards,

Mana

[PrashantSangle]

Hi,

What error you are getting for your expression??

try

sum( [Wit Quantity Second Unit]) /Sum( [Factor] )

or

[Wit Quantity Second Unit] / [Factor]

Regards

[sasiparupudi1 · Accepted solution]

If you need a modulo operation , use the following

for real numbers

fmod([Wit Quantity Second Unit] ,[Factor])

for integers

mod([Wit Quantity Second Unit] ,[Factor])

[#4]

thanks