Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table which has 20 expression fields. This makes it busy. But whenever there is a filter applied this works just fine. I was wondering if there is a functionality which I can use to display the table only when its not busy or else display the message 'Select Filter1/Filter2/Filter3'
go to chart properties-> General Tab-> In calculated condition put below condition
getselectedcount(Filter1)>0 and getselectedcount(Filter2)>0 and getselectedcount(Filter3)>0
Now Click on Error Messages button, then click on Calculation condition unfulfilled and type
Please select Filter1/2/3
Try this in your Straight table Chart General tab:
go to chart properties-> General Tab-> In calculated condition put below condition
getselectedcount(Filter1)>0 and getselectedcount(Filter2)>0 and getselectedcount(Filter3)>0
Now Click on Error Messages button, then click on Calculation condition unfulfilled and type
Please select Filter1/2/3
Thank you Vishwarath. That works fine. But when I have =GetSelectedCount(Filter1,Filter2,Filter3)>=1 on calculation condition it doesn't work. I have also tried or in place of , .
Thank you Kushal it worked