"if-then-else" formula available in C4C?

[former_member1309129]

I would like to add a key figure in my report, which is using an if-then-else criteria.

If the sales order value = 0 then use the sales quote value else use the sales order value.

I could not find an option for a if then else formula, is this available ?

[former_member497128]

Dear sp.re,

We do not have any option to use "if then else" in key figures.

You can try to achieve the same in excel (by using some formula/lookups).

Regards,

Saurav Kumar