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

Avatar

Avatar

salvdangelo

Avatar

salvdangelo

salvdangelo

09-10-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

salvdangelo

Avatar

salvdangelo

salvdangelo

13-11-2017

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

Answers (2)

Answers (2)

Avatar

Avatar

florentlb

Avatar

florentlb

florentlb

13-11-2017

Hi Salvatore,

Were you able to get the result you wanted?

Let me know,

Florent

Avatar

Avatar

florentlb

Avatar

florentlb

florentlb

30-10-2017

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