Post

4 followers Follow
1
Avatar

Round() function should work on Currency fields

We are using multiple currencies in Clarizen. Say we calculate and set an hourly rate as (Salary / 2000) in a Custom Action. We should be able to use the Round() function here to round the result, otherwise we end up with a rate like 78.12436532 USD.

Ekin Caglar Not planned

Official comment

Avatar

Any reason not to use: Round($C_YourField/Currency(1),0) ?

David Goulden
Comment actions Permalink

Please sign in to leave a comment.

4 comments

0
Avatar

I completely agree - I have been complaining about this missing feature since we onboarded,  is this on the roadmap for future updates ?

Jim mcphee 0 votes
Comment actions Permalink
0
Avatar

that works if you want it rounded to a numeric field, but if you want to keep it as a currency field then you have to convert back to a currency.  which is very clunky for such a simple feature.

 

To be honest I think all currency fields should be defaulted to 2 decimal places with an option in settings to turn off the feature

Jim mcphee 0 votes
Comment actions Permalink
0
Avatar

The workaround I found for this is smt. like below.
For work items we have RevenueCurrencyType field which holds the currency type as text.
So in order to show a string value of a currency with the type, I used the following snippet in workflows.

{ToString(Round($C_ACurrencyField / Currency(1), 2))} {$RevenueCurrencyType}


But definitely there should be some more helper functions that let us easily format currency values.

Mustafa Kipergil 0 votes
Comment actions Permalink