#5949: Quire Feedback
狀態: 已完成
標籤: 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.

建立者 (deleted-q240) 2024年1月12日, 已編輯 2024年1月18日

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

(deleted-q240), 2024年1月12日

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, 2024年1月12日

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, 2024年1月12日