Sign in to Community
Sign in to view all badges
Hopefully a simple issue:
Making the division (or using a percent function) A = B/C such as A,B,C are "double" typed for some reason the result is rounded to the next integer.
Iif(B=0, 0, (A*100)/B)
Iif(B=0, 0, Percent(A,B)*100 )
Example: B = 2C = 3Result A= 67.00Expected A= 66.66
Any idea ?
I solved this issue using "Percent" but still I cannot understand why the division of two doubles give as a result an integer number without decimal part.
Were you able to get the result you wanted?
Let me know,
Can you try using the Round function in your calculation? Round(<number>, <number of decimals>)
Let me know if that would work for you,