Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i want to use a conditional in one of the expressions of my straight table.
I want the metric appear or disappear depending on the field, example
if i have vendor=1 i want the expression to make a sum(), so as if i have vendor=2 but if i have vendor=3 i want to appear nothing like ' '.
I used this expression(obviously didn't work): =if(Vendor= '1', sum([metric_1]), if(Vendor= '2', sum([metric_1]), ' '))
I tried backwards as: =if(Vendor= '3', ' ', sum([metric_1]))
didn't work either.
I hope you could help me!
thanks in advance
Try this instead
Sum({<Vendor = {'1', '2'}>}[metric_1])
sill doesn't work, it shows the same for all the fields (the sum of the expression) despite the vendor
Would you be able to show this using an example?