Configure function field in a report (percentage/decimal and currency)

[PaulaaO]

Hi,

I have a report requirement where I need to display the calculation between a percent_complete type field and a currency type one and I was wondering if I could achieve this via a function field created directly within the report.

I had a go using the multiply () function but without success and I believe it's due to both fields being of different types. The percent_complete field is custom and I can update its type to decimal if that would make any difference.

Is there any way this can be done using function field from Reporting or should I try other avenues, e.g. calculated field?

Thank you in advance 🙂

Paula

[Dr Atul G- LNG]

Hi @PaulaaO I doubt this can be achieved with different data types, as functions mainly work with the same data type.

[Ankur Bawiskar]

@PaulaaO 

Function field multiple will work when you have 2 values which are numeric either integer/float/decimal.

Try getting the currency value using substring function and then multiple both the fields. Make percent complete as decimal

If the above doesn't work then

please use a custom field and make it calculated and add script in that

then use that field in your reporting

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@PaulaaO 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@PaulaaO 

@PaulaaO 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏