Official comment
Any reason not to use: Round($C_YourField/Currency(1),0) ?
Comment actions
Post
Follow
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.
Please sign in to leave a comment.
4 comments
Date
Votes
I completely agree - I have been complaining about this missing feature since we onboarded, is this on the roadmap for future updates ?
Comment actions
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
Comment actions
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.
Comment actions