Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
Hi,
What error you are getting for your expression??
try
sum( [Wit Quantity Second Unit]) /Sum( [Factor] )
or
[Wit Quantity Second Unit] / [Factor]
Regards
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])
thanks