IsNull Syntax

[#1]

I want to use Isnull in this set expression:

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

instead of ZIP=, Name=, TERRITORY=

what is the proper syntax for this ?

[kaushiknsolanki]

Hi Sumit,

    When you use Zip=, Name=, Territory = in set analysis, this doesnt mean you are taking null values from this field. This statement means do not consider any selection made in this fields i.e Zip,Name and Territory.

    I hope the idea is clear, if not please elobrate in details.

Regards,

Kaushik Solanki

[#3]

I know that but in this case that condition is not working. If  i am making selection in Zip, name or Territory.. it is changing the value of the expression. I dont know why ??

[kaushiknsolanki]

Hi,

   Will you please share the sample application.

Regards,

Kaushik Solanki

[#5]

Actuallu my application is very huge in size. so i cant upload the file

[kaushiknsolanki]

Hi,

   Can you try to create a sample application to show this problem.

   Cause unless we see what you are doing, we wont be able to solve this.

Regards,

Kaushik Solanki

[#7]

sum({$ <Dimension=>} Field)

--> will give the sum of "Field", not considering the "Dimension" selection (as if all values of "Dimension" were possible).

sum({$ <Dimension={}>} Field)

--> will give the sum of "Field", not considering the "Dimension" selection but filtering only on lines where "Dimension" is null / empty.