Hi,
I have a custom field called $C_JobTitleRegularHourlyRate which is Currency Type.
I want to extract the Currency Type and Amount from this Field.
At Present it is coming like Eg. 1000 SEK, 1000 USD like this.
I want to get this "1000 SEK" in two different field as like below
Amount Currency Type
1000 SEK
1000 USD
Is there any way to separate this data.
Kindly help !
Thanks
Vijay
Just updating this old thread with a note that we have a dedicated function for this.
Previous Option:
Right(toString($PlannedBudget),3) <> Right(toString($Project.CostCurrencyType),3)
New Option with Function
GetCurrencyType($PlannedBudget) <> ToString($Project.CostCurrencyType)
Please sign in to leave a comment.
Moving to customization thread.
Hi Vijay,
To separate the value one needs to create two variables, one numeric and the other one text.
The definition of the Amount variable: Amount = $C_JobTitleRegularHourlyRate/Currency(1)
The definition of the Currency Type variable: Currency Type= Right(ToString($C_JobTitleRegularHourlyRate),3)
Hope this helps.
Thank you,
Bea