Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All, I am trying to copy and expression I have within one of my created fields:
=if(MATCH(FRUIT,'APPLE') AND MATCH(SEASON, 'SUMMER') AND NOT MATCH(RAIN, 'NO') AND MATCH(LOCATION,'UK'), Dual('LC',1),0)
This within a Field Expression works perfectly. Creates a Field that has LC and Other and when select LC, I can see all the filters. ie. FRUIT is APPLE, SEASON is SUMMER etc.
But when I move this expression in to a load script to create a column. The filtration does not work.
Any help is much appreciated,
Aksel
So, essentially you are looking for the values within FRUIT and LOCATION to be selected when you click on the SEASON list box? You can do this using triggers, but one thing to note here is that when you select within Testing, the possible values are the same values which are selected when you select in SEASON (calculated list box). It means that you should still be able to see the result for only those FRUIT and LOCATION which are possible when you select Testing.
Would you be able to share a sample where we can see the issue?
So, essentially you are looking for the values within FRUIT and LOCATION to be selected when you click on the SEASON list box? You can do this using triggers, but one thing to note here is that when you select within Testing, the possible values are the same values which are selected when you select in SEASON (calculated list box). It means that you should still be able to see the result for only those FRUIT and LOCATION which are possible when you select Testing.