Save Number Field Value in Euro Currency

[Dietrich]

Hi all,

I'm having trouble with the following scenario and was hoping someone could help:

When a customer logs a ticket, there is a custom field called Word Count where they will specify a number, for example 100.

Using that, I need to calculate the Cost of the job, saving the result in a different custom field called Cost. The final value for Cost must be displayed in Euro, with only two decimals.

This is the smart value I'm using at the moment to get the Cost with two decimals: 

{{#=}}ROUND({{issue.Word Count}} * 0.094, 2){{/}}

The above is working perfectly, but I can't seem to get the value to display in Euro.

I've tried asCurrency but that's for USD, and asCurrency("fr_FR") which shows Euro in the documentation just clears the value.

Help please? :)

[Hariharan Iyer · Accepted solution]

Hi @Dietrich ,

Would you mind sharing your entire rule and/or the audit logs. AFAIK, if you store the above in a variable, and then set the value of the field as {{var.asNumber.asCurrency("fr_FR")}}, it should just work.

BTW, I noticed it was empty when I didn't have the asNumber, so maybe that's what you're missing, but it's hard to say without more information.

[Dietrich]

Hi @Hariharan Iyer 

Thanks for getting back to me - this is what I've got:

[Hariharan Iyer]

Thanks for the response, Dietrich. Can you try setting the field value to 

{{CalculatedCost.asNumber.asCurrency("fr_FR")}}

[Dietrich]

Thanks @Hariharan Iyer , it's working perfectly now so I'm very happy!

Much appreciated!