The error is related to the use of the ATTR function in the Current Penetration calc.
Could you share how is the Fixed Penetration calc? I believe that Fixed Penetration is an aggregation and that's why you are being forced to use ATTR in the Current Penetration. Maybe if you not use the aggregation in Fixed Penetration you can remove ATTR from Current Penetration and aggregate it all in the LOD
If you could share the workbook it would help a lot too.
1 of 1 people found this helpful
You cannot use a table calc or attr function in LOD. You can try Rodrigo's suggestion. Apart from that here are my inputs.
In your calculation use MIN function instead of attr.
And then use it directly in the second calculation.
You can also write this in a single calculation as:
Hope this helps.
Update the formula for the Current Penetration as given here and see if it works:
IF YEAR([Week Ending])=YEAR([Trans Date]) THEN [Fixed Penetration] END