Result of a "double" division gives an integer with no decimal as result

[salvdangelo]

Hi,

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)

or

Iif(B=0, 0, Percent(A,B)*100 )

Example:
B = 2
C = 3
Result A= 67.00
Expected A= 66.66

Any idea ?

Adobe Campaign​

[florentlb]

Hi,

Can you try using the Round function in your calculation? Round(<number>, <number of decimals>)

Let me know if that would work for you,

Florent

[florentlb]

Hi Salvatore,

Were you able to get the result you wanted?

Let me know,

Florent

[salvdangelo · Accepted solution]

Hi Florent,

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.

Salvatore