Rounding Down In Alteryx

[JMSCurrencies]

Hi Everyone!

Hopefully you can help with this issue - i'm trying to round-down my values when multiplying commission value by rate

Commission	Rate	Desired
133.2	0.5	66.6
2.26	0.5	1.13
68.6	0.5	34.3
70.96	0.5	35.48
1813.25	0.5	906.62

Thanks in advance!

[Jonathan-Sherman · Accepted solution]

Hi @JMSCurrencies,

You could use:

IF Mod(Round([Commission] * 100, 1) ,2) = 0

THEN [Commission] * [Rate]

ELSE Floor([Commission] * 100 * [Rate])  / 100

ENDIF

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan