Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Yes. that is what I used and it worked. The data model stinks...I know.