Converting numbers to text without losing decimals
I am trying to create a reporting module with mixed line items (numbers and percentages) so I am converting the numbers to text for display purposes only.
We need 1 decimal and have very small numbers eg. 0.0001 which should then be displayed as 0.0 however during the process the decimal is lost.
Same issue with integers: they are displayed as 3 instead of 3.0
This is how it is in Anaplan currently:
- ACT is text using TEXT(ACT1)
- ACT1 is in number format
Thank you for your help in advance!