set analysis

[#1]

Hi,

I was wondering if instead of doing:

sum($<Region={America}>} Sales)

could I do:

sum($ upper(Region)={AMERICA}>} Sales)     ?

[jpapador]

You would have to do that in the load script.  I don't think it lets you use commands like that in set analysis.

[Oleg_Troyansky · Accepted solution]

Eric,

no, this would not be correct. Set Modifiers should always look like the following:

Field = {.... } - the = sign might be replaced by other signs, but the Field name should remain there "as is".

You can, however, use the search functionality and express your condition as part of the search:

sum({$<Region ={"=upper(Region)='AMERICA'"}>} Sales)

Notice the double quotes signifying the search condition and the equal sign in front of the search condition.

Oleg Troyansky

www.masterssummit.com

www.naturalsynergies.com

[#4]

thanks!