*** Need help with Aggr() Expression ***

[IAMDV]

Dear All,

I am stuck with an expression which works fine when I filter the data and it gives incorrect numbers when I dont filter the data. Here is the expression...

Dimension :

ParentID

Expression :

SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId))

This works fine, when I filter on the Field ParentID (Which is my only dimension). However, if I dont filter on the ParentID it gives incorrect numbers. I am not sure where is the problem. Unfortunately I cant load the QV document because it contains sensitive information. Can someone please help...?

Thanks a ton in advance.

Cheers - DV

[danielrozental · Accepted solution]

Try

SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId, ParentId))

[IAMDV]

Daniel – Thanks so much for quick response. This was a silly question... I went back last night and referred the documentation again and gotit working.

Cheers - DV