Ifempty with deeper brackets inside

How To
1

Hi,

I’m trying to use ifempty with more brackets inside of it, but it doesn’t seem to work. Is there a way to successfully do something like:
image

The behavior I get is that if there is something in A, it will pick that, but if A is empty, it won’t do the value of B, gives me a 0).

2

You are repeating the formula. The ifempty should only be used to wrap the two variables

{{ -(ifempty(var1; var2) / 100) }}

3 Likes
3

Much obliged. I guess I was thinking too much in formula within formula when I could have solved it simpler. :grinning:

2 Likes