Same expression in KPI not working

[gauravgg]

Hi all

I have the following expression   in Table

(Max(aggr(sum(PRICE_MAT_New),MATERIAL,PLANT,VENDOR,PRICE_MAT_New))

-

Min(aggr(sum(PRICE_MAT_New),MATERIAL,PLANT,VENDOR,PRICE_MAT_New))

)

*

FirstSortedValue(VOLUME,

-aggr(sum(VOLUME),MATERIAL,VENDOR,PRICE_MAT_New)

)

When i export the table in excel and sum the calculated column it comes around 66 cr

But the same expression when i put in KPI object it shows some different value

In KPI also it should show 66 cr.

Can anyone help me in this?

Thanks in advance

[tresesco]

Try using an aggregation on your expression, like:

Sum( Aggr( <YourExpression> , <Dimension in chart>))

[gauravgg]

hi Tresesco ,

I tried ,but there might be some syntax error.

Can you help me in converting the expression into aggr

[tresesco]

Please share your sample app.

[mdmukramali]

Hi,

What is the output you are getting when you are using only below expression in the KPI.

FirstSortedValue(VOLUME,

-aggr(sum(VOLUME),MATERIAL,VENDOR,PRICE_MAT_New))

?