Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I have a question. How I have to define the condition to my table so that I get zeros for all entries for a special filter? My table looks like below.
I tried this to see what happend:
If(Filter1="S",0,1)
But when I select the S at Filter1 I get an error message : Condition for calculation not fulfilled.
My problem is that I have no data for this filter until Dec22. Therefore I wanted to show zeros all of my entries.
Thank you for help
Hi,
I do not fully understand your use case, so may not be the right solution.
But if you are trying to evalute something being selected you want to use the GetFieldSelections() function
Something like
If(GetFieldSelections(Filter1)="S",0,1)
Hi @Mark_Little
okay I try to explain it more understandable.
My original data looks like that
I have a region, date, Filter1, Filter2 and the count of this kinds. And If you can see if Filter1 is L or S there are no values for these months. To get an better overview I created a cross-table like above, where you have the count of every region for each month. Now what I would like to have is if I select Filter1=S, my cross table should show me for every cell 0 beside Dec-22.
I tried your suggestion but it does not work 😞