Forum Index

No notifications
Notifications

Favorites

No favorites found
Ask the community Need help to achieve something? - Ask the Community
Join the Conversation > Ask the community > Decimal places in a Variable View modes: 
User avatar
KnowledgeKube Staff
KnowledgeKube Staff
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.


User avatar
Advanced member
Advanced member
scot.jones - 25/01/2017 17:02:27
   
RE:Decimal places in a Variable

Update:

I've noticed if you apply the culture to a value of 0 the preceeding £ doesnt appear.  Is it possible to ensure you would get the preceeding £?


User avatar
KnowledgeKube Staff
KnowledgeKube Staff
matt.pitman - 29/12/2016 14:38:15
   
RE:Decimal places in a Variable

When using any function that accepts a culture code, you may find the following link useful:

Table of Language Culture Names

Kind regards.
 


1 2 3
RSS Feed