Grand Total in Expression

[#1]

Hi

I am sharing a file, Whcih is quite interesting. I want Grand Total in my Last Column i.e. - Test1. Value should be 59, Please don't change in logic. Which is correct, Only grand total should be 59 which is coming in subtotal.

Thanks in Advance.

[MK_QSL]

IF(Dimensionality() = 1,  Column(1) * Column(7))

[MK_QSL]

IF(Dimensionality() = 1,  Column(1) * Column(7),Column(1) * Column(7))

[#4]

Grand total is coming 726722.50, Which is worng. Clear All and check. the same expression.

[CELAMBARASAN]

Hi,

Are you looking for this

If(RowNo() = 0 or Dimensionality() = 0, Column(1) * Column(7), 0)

Hope it helps

[#6]

Thanks for reply, But in this condition My Grand Total is coming 726722.5.

If u will export the whole chart in excel in XLS. check the Total - It is 35097.36.  I want this value.

[CELAMBARASAN]

The QV file you uploaded gives me 32539586872.5682

Where Outlook = 36075839

SS Adh % SKU = 901.977272727273

Result is correct as per the logic. I didn't get how it is wrong?

[#8]

Hi Amit,

You can try following Expression

(if(rowno()=0,

(column(1)*column(7)) ,

if(ISNULL(RowNo())

,

if(IsNull(RowNo()),SUM(AGGR(sum(aggr(

if((sum(aggr(((sum(ClosingStock))/((((sum(Outlook))*(avg([Safety Stock Norm])))/30))),CalendarDate,[2nd Item Number])))>1,1,

if((sum(aggr(((sum(ClosingStock))/((((sum(Outlook))*(avg([Safety Stock Norm])))/30))),CalendarDate,[2nd Item Number])))>0.7 and

(sum(aggr(((sum(ClosingStock))/((((sum(Outlook))*(avg([Safety Stock Norm])))/30))),CalendarDate,[2nd Item Number])))<=1,0.5,0)) /vMaxDay,CalendarDate,[2nd Item Number]))

*SUM(Outlook)

,[2nd Item Number])))

,0)) )