Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=IF(GetFieldSelections(SalesOffice)='NA38' AND GetFieldSelections(SalesOffice)='NA40' ,100,60)
GetFieldSelections will return multiple value separated by commas in a single string if multiple values are selected, so the comparison to a single value in a string will not work.
Try this:
if(GetSelectedCount(SalesOffice)>0 and
Match('NA38',$(=concat(distinct chr(39)&SalesOffice&chr(39),',')))>0 and
Match('NA40',$(=concat(distinct chr(39)&SalesOffice&chr(39),',')))>0,
100,60)
GetFieldSelections will return multiple value separated by commas in a single string if multiple values are selected, so the comparison to a single value in a string will not work.
Try this:
if(GetSelectedCount(SalesOffice)>0 and
Match('NA38',$(=concat(distinct chr(39)&SalesOffice&chr(39),',')))>0 and
Match('NA40',$(=concat(distinct chr(39)&SalesOffice&chr(39),',')))>0,
100,60)
Thankyou its working 🙂
GetFieldselections not working with AND Condition with different dimensions
=If(GetFieldSelections(Crop)='Tomato' and GetFieldSelections(Species)='Tomato',1,0)
Please help for this Expression @GaryGiles
I have tried this below expression but it is not working.
=if(GetSelectedCount(Crop)>0 and GetSelectedCount(Species)>0 and
Match('Tomato',$(=concat(distinct chr(39)&Crop&chr(39),',')))>0 and
Match('Tomato',$(=concat(distinct chr(39)&Species&chr(39),',')))>0,
1,0)
please help
That looks like it should work. Are you sure that Tomato is selected in both Crop and Species and that a fact row exists for that combination?
yes I have selected both and fact row exists for both combinations. But not working.
Is there any other expression which helps me when user select Crop = Tomato and Species = Tomato then only chart should be visible?
Can you post the results of these 2 expressions with and without the selections made?
concat(distinct chr(39)&Crop&chr(39),',')
concat(distinct chr(39)&Species&chr(39),',')