Help in expression

bharatkishore — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i Have the below expression written in script:

=(Cons_YTD_LY)*((ADJ_CONS_YTD_LY)/(YTD_Consumption_LY))

I am getting the value as 467K

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

=sum(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 Help in expression in QlikView