How to use "IF" formula (like in excel) in DOMO

Hello guys!

I have a database with information about customers, and their payments (1st payment, and Net_value).

Each customer have a type of subscription, and each subscription have a specific rule. So if my customer is the subscription "A" i need to use the "1st payment", and if the customer is the subscription "B" i need to use the "Net_valeu". In excel i use the "IF" formula. In DOMO, on beast mode i dont have this.

How can i do this in domo? Can i use the CASE formula?


Thanks

Answers