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

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

20200507 - RegexParse.yxmd