Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId, ParentId))
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