Set analysis not satisfying all conditions

[ipauldur]

Hi All,

I am using the below expression in the pivot trable.

Sum ({<YearMonth={"$(vReport_YearMonth)"},Revised_GTO_Flag={1},GTO_Flag={1},_Data_Option={1}>}Area_Less_NTD)

Actually, i have the field "Revised_GTO_Flag" field in the table. But there is nothing (Value) for this field. So when i include in the expression its showing the value for satisfied all other conditions. Originally, i should get zero for this expression.

Please suggest me, how to modify this expression for getting zero value.

Thanks,

Durai.

[#2]

Hi,

Try the below expression.

Sum ({<YearMonth={"$(vReport_YearMonth)"},Revised_GTO_Flag={"1"},GTO_Flag={"1"},_Data_Option={"1"}>}Area_Less_NTD)

Regards,

Desmortes