Expression help

[bharatkishore]

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