#5949: Quire Feedback
Status: Completed
Tag: Resolved

Hi

I am using a formula to return an exchange rate based on a currency:

Currency="GBP"?1.0:(Currency="USD"?0.79:(Currency="CAD"?0.59:(Currency="EUR"?0.86:0.0)))

This works ok but I cannot sum this column in table view. It just returns zero.

Created by (deleted-q240) Jan 12, 2024, Edited Jan 18, 2024

Yup it works. I can also wrap it in a SUM() too.

(deleted-q240), Jan 12, 2024

Hi, thank you for your feedback.

We will pass this on to our team for further troubleshooting. We will keep you updated as soon as we have any updates from our team. Thank you, and we are sorry for the inconvenience.

Golda, Jan 12, 2024

Hi, I wanted to inform you that you can change your formula to the following: (Currency="GBP"?1.0:(Currency="USD"?0.79:(Currency="CAD"?0.59:(Currency="EUR"?0.86:0.0))))[0]

Please give this a try and let me know if you have any further questions. Thank you.

Golda, Jan 12, 2024