How to round off an decimal to a whole number

[nazuk]

Hello All,

Need help in knowing how i can round off my decimal (double) data type to a whole number. So i have a currency as a column whenever currency is JPY i have round off it to a whole number?

[RolandSchubert · Accepted solution]

Hi @nazuk ,

if I got the point, you want to round values based on the content of a second column, so if [Currency] is 'JPY', round to whole number, for other currencies leave decimal laces as they are. This should be possible using a formula like 

IF [Currency] = 'JPY' THEN
Round([Value], 1)
ELSE
[Value]
ENDIF

I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland