Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a variable (vHO) and a field Country
(vHO) is a calculating buckets dynamically after some selections
So i am trying to ignore (vHO) in one formula with country.
Count({<Country=,$(=vHO)=>}ID) is not working.
So i need to use a variable to exclude during a calculation .. can i do that.
Hi Madhur, this can work if vHO contains the field name you want to ignore, you can try adding this expression to a table without caption, so you can see the expression in the column title and check how it's expanding $(=vHO),
Maybe you only need to remove the =:
Count({<Country=,$(vHO)=>}ID)