Hi All,
Β
I want to truncate the decimals from a number like below but do not want to round it.
2.22939393 -> 2.229
2.22977777 -> 2.229
2.59999 -> 2.5 instead of 2.6
Seems that would always be a round down.
Can you use the ROUND function?:Β ROUND(Line Item, [decimal places], DOWN]
If you do not want to round then your only other option is text cutting.
You can do LEFT(TEXT(number line item),5)
You can have an IF statement to not always take the 5 first (2.229) but the first three (2.5), depending on a numeric condition.
Hi, Thanks for your reply but Round down will not work as it will round 3.4562 to 3.0 instead of 3.4. I want a way to truncate the number till the first decimal
Is there any way to have the last item of the waterfall be a running total that starts from 0 and shows the net of the previous waterfall components? I'm using line items here, would just want the Ending NAV to always start at 0
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.β¦
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplanβ¦
