Calculated Dimension

[tmumaw]

Ok guys need a little help with calculated dimensions (Haven't went down this route yet). I have 2 fields QTY and TIMES WORKED. I am trying to get a simple status. This is what I have tried but with no luck. If the statement is true I want to use the literal 'In-Process' else the actual status description.

Thanks

=if(QTY - if(Status = 'NS',0,(count(Distinct WEDAT))) < QTY,'In-Process', [STATUS DESC])

[deepakk]

hi,

when you are using calculated function like count or sum in calculated dimension we have to use aggr function.

aggr(count(t2), t1)..

[tmumaw]

where would the aggr be placed and would I only use one?

[deepakk]

hi,

I hope the attach application helps you out.