Expression help

bharatkishore — Tue, 15 May 2018 12:58:32 GMT

Hi All,

i Have the below expression written in script:

(if(if(IsNull(YTD_Consumption_LY),0,YTD_Consumption_LY)=0,if(IsNull(Cons_YTD_LY),0,-Cons_YTD_LY),

if(IsNull(Cons_YTD_LY),0,-Cons_YTD_LY))*(ADJ_CONS_YTD_LY/YTD_Consumption_LY)) as Adj_Consumption,

I am getting the value as 467K

Now when i write the below expression in text box i.e.

=sum(if(if(IsNull(YTD_Consumption_LY),0,YTD_Consumption_LY)=0,if(IsNull(Cons_YTD_LY),0,-Cons_YTD_LY),

if(IsNull(Cons_YTD_LY),0,-Cons_YTD_LY)))*(sum(ADJ_CONS_YTD_LY)/sum(YTD_Consumption_LY))

i am gettiing the value i.e. 568K

Can you please help me where i am doing wrong in my script expression..

Thanks,

Bharat

topic Expression help in QlikView