Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to respect the selections made before applying the set analysis rules?
Hi, Kristy
In this case set analysis would be an AND operation. You can use the *=
In the following expression you get the sales acoording to user selection only if they are also from John or Peter. If you your selections does not include John or Peter you will get 0.
=
sum({<[SalesMan] *={John,Peter}>} AMOUNT)
Hope it helps!
Regards,
Erich
Kristy,
The set identifiers identify what record set the set analysis is based on:
$ = the records of the current selection
1= the full set of all the records in the application
take a look at the manual for some examples
Regards,
Gordon
I understand the use of $ and 1. However, the problem I am trying to solve is this... If my set analysis restricts to a specific filter (ie. date = 1/1/2011) and I make a date selection that is not 1/1/2011, I want my results to return null, 0, blank, or something other than the results for 1/1/2011 respecting the date selection.
Hi, Kristy
In this case set analysis would be an AND operation. You can use the *=
In the following expression you get the sales acoording to user selection only if they are also from John or Peter. If you your selections does not include John or Peter you will get 0.
=
sum({<[SalesMan] *={John,Peter}>} AMOUNT)
Hope it helps!
Regards,
Erich
Thank you. I think I can use this logic to accomplish what I need.