Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try the below expression.
Sum ({<YearMonth={"$(vReport_YearMonth)"},Revised_GTO_Flag={"1"},GTO_Flag={"1"},_Data_Option={"1"}>}Area_Less_NTD)
Regards,
Desmortes