Sum Distinct Aggr value

[cliff_clayman]

I have a field (JobID) that has multiple records for various other data fields.  One of the fields (JobCost) is displayed multiply times, but I just want to get a single value for it.  How can I get the distinct JobID and get just a single value for the JobCost?

[swuehl · Accepted solution]

Maybe like

=Sum(Aggr(Only(JobCost),JobID))

But it would probably better to remodel your data / change your load script to not duplicate your facts.

[cliff_clayman]

Yes. that is what I used and it worked.  The data model stinks...I know.