Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a requirement where I want to convert my if statement to pick (match()). But I am confused on how we do it.
My Expression:
if(GetSelectedCount(Country)=0, sum(revenue),
if(GetSelectedCount(country)>0 and GetSelectedCount(state)=0,Sum(Sales),
if(GetSelectedCount(State)>0,count(Employees)
)
))