IF Formula in Numeric ( Selected Currency )
Dear Expert, I Need some Help to solve my formula as below and I need to calculate Total Amount Price base on currency I have fields Currency : Multiple choice ( AUD, Euro ) qty : Numeric ...
Forum Discussion
Hi There Quickbase Admin!
Happy to help with this one!
From what your formula reads:
If ([Currency]="AUD", [Total Estimate AUD],[Total Estimate AUD]*[Exchange rate],
--> This is saying to display the [Total Estimate AUD] field when the [Currency] field equals "AUD", ELSE (so if it equals "Euro" being that from your description, there are only two choices), it runs [Total Estimate AUD]*[Exchange rate]
[Currency]="Euro", [Total Estimate Euro],[Total Estimate Euro]*[Exchange rate])
--> This states a similar process, but for "Euro", so now there are two clashing conditions for the "Euro" selection.
Would you mind giving some detail as to what you are trying to achieve / display so I can better help troubleshoot the formula?
Thank you!
------------------------------
Manny De La Cruz
Customer Adoption Manager
Quickbase
------------------------------
Happy to help with this one!
From what your formula reads:
If ([Currency]="AUD", [Total Estimate AUD],[Total Estimate AUD]*[Exchange rate],
--> This is saying to display the [Total Estimate AUD] field when the [Currency] field equals "AUD", ELSE (so if it equals "Euro" being that from your description, there are only two choices), it runs [Total Estimate AUD]*[Exchange rate]
[Currency]="Euro", [Total Estimate Euro],[Total Estimate Euro]*[Exchange rate])
--> This states a similar process, but for "Euro", so now there are two clashing conditions for the "Euro" selection.
Would you mind giving some detail as to what you are trying to achieve / display so I can better help troubleshoot the formula?
Thank you!
------------------------------
Manny De La Cruz
Customer Adoption Manager
Quickbase
------------------------------