Set Expression Error

[#1]

I have used the following set expression to calculate my value and made it free from ZIP, Name and Territory selection by passing  ZIP=, Name=, TERRITORY=  (i.e. Null Values) but still if i am making any selection in ZIP, Name and Territory the value of my expression is changing. What could be the reason.

sum({$<%EPID={1},Segment={'Advocates'},ZIP=, Name=, TERRITORY=>} (eTRx_Volume))/sum( {$<%EPID={7},Segment={'Advocates'}, ZIP=, Name=, TERRITORY=>} (eTRx_Volume)

My Expression is

[#2]

Try with isnull(ZIP), isnull(TERRITORY).. instead of ZIP=,TERRITORY=

Swapnil

[#3]

How do u write Isnull in Set Expression. I am trying

sum({$<%EPID={1},Segment={'Advocates'}, Isnull(ZIP), Isnull(Name), Isnull(TERRITORY)>}

but this is giving me an error

[jagannalla]

No it should work perfectly according to your expr. Can you share your sample file so it helps us to look on it.

[SunilChauhan]

use below code

sum({<%EPID={1},Segment={'Advocates'},ZIP=, Name=, TERRITORY=>} (eTRx_Volume))/sum( {<%EPID={7},Segment={'Advocates'}, ZIP=, Name=,TERRITORY=>} (eTRx_Volume) )

hope this helps

[#6]

I am using the same expression but it is not working.

[SunilChauhan]

can you attached a sample file

??????