Order Of Execution

BRRLL99

Hi,

this the formula I have used to convert millions into billions, can someone explain the order of execution for this formula especially

THEN

if contains([_CurrentField_], 'M')

then '$'+tostring(tonumber(REGEX_Replace([_CurrentField], '[$M]', ''))/1000)+ ' B'

else [CurrentField] endif

DataNath

@BRRLL99 when dealing with nested/wrapped functions like this, they work inside out. Therefore (assuming your ‘if’ condition is met of course)…

1) $ and M are replaced with nothing

2) The result of the record after removing $/M is temporarily made into a number

3) That number is divided by 1000

4) The result is then converted back to a string, which is placed in between $ and B