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

Total Posts

1.1K

Likes

235

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb

13-11-2017

Hi Salvatore,

Were you able to get the result you wanted?

Let me know,

Florent

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
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