Forum Index

No notifications
Notifications

Favorites

No favorites found
Ask the community Need help to achieve something? - Ask the Community
Subscribe to post
User avatar
Rikard - (26/01/2017 11:41:51)
RE:Decimal places in a Variable

Hi Scot, I’ve tested this function and confirmed what you’ve described, so this is something we’ll need to investigate in more detail. Thanks for bringing it to our attention! :)

In the meantime, you can create a work-around by using an If-statement to return a formatted string if the input value is zero, like in the following example:

if(CalculationResult=0,"£0.00",FormatNumber(CalculationResult,"en-GB","{0:C}","en-GB"));

If the input value is a non-zero number, the statement will return the properly-formatted string as before.

RSS Feed