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])

[matt_crowther]

Thom,

Might be overly simplistic but try putting a sum() round each of the 'QTY' entries.

If that doesn't work I'd post a sample file as what you're trying is entirely possible.

Hope that helps,

Matt - Visual Analytics Ltd