☝️Small business or a startup? See if you qualify for our special offer.
+

Is it possible to apply currencySymbol conditionally based on the currency of the row?

Answered
Bill Kaper asked on July 29, 2025

We have a use case where a pivot table can be made up of multiple currency values. We force a user to dimension based on the currency code, so the same currency amounts are grouped together and disparate currency amounts are not aggregated together. We would like to apply conditional formatting for currencySymbol to the currency amount based on the currencyCode dimension. Is there a way to do this today in FlexMonster?

2 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster July 30, 2025

Hello, Bill!

Thank you for reaching out to us.

Flexmonster does not support number formatting with conditions based on other cell values; it only applies formatting to a specific measure. We recommend using the customizeCell function (an API call that allows the customization of separate cells) to apply conditional currency formatting. When processing cells, you can implement a condition based on the adjacent member in rows or columns, based on which the cell text can be modified to include the appropriate currency symbol: https://jsfiddle.net/flexmonster/mkhwgxto/

Please let us know if this solution would work for you.

Best Regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster 18 hours ago

Hello, Bill!

Hope you are doing well.
We are wondering if you have time to check the provided solution for formatting cells based on adjacent member values using the customizeCell.
Please let us know if it works for you.

Best Regards,
Maksym

Please login or Register to Submit Answer