Hi,
I'm trying to create a calculate field to obtain an average. I'm taking one calculated field (Paid Loss) and / by another calculated field (Count of Claims Paid. I'm trying to calculate the average cost of claims paid by quarter.
Paid Loss is just Paid Loss based on a parameter
IF [Filter for Timeframe] = TRUE THEN [Loss Paid Amt] END
Count of Claims Paid is
COUNTD(IF [Paid Loss] >0 THEN [Claim Number] END)
This is giving me the error:
[Paid Loss] / [Count of Claims Paid]
I'm sure it has to do with the count aggregation in my Count of Claims Paid field but I'm not sure how to resolve. Any help would be greatly appreciated.
Thanks,
Shannon
can't tell about the first formula but the next 2
COUNTD(IF [Paid Loss] >0 THEN this needs to be aggregated [Claim Number] END)
this needs to be aggregate [Paid Loss] / [Count of Claims Paid]
see the article on my blog at See it your way: FAQ Series- Cannot Mix Aggregate and Non-aggregate
it will explain aggregation
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
