its because you are mixing aggregated (PriorYear HC) and non-agreegated.
provide a sample book to assist further
1 of 1 people found this helpful
if ATTR([Metric] )= 'Headcount' and MIN( [Week End Date] )= [PriorYear HC]
then COUNT([Employee Count] )
The solution will depend on how your workbook looks like, can you provide a sample workbook?
This worked. thank you
Great!!! Pl take a sec and close THread by marking my reply as CORRECT. The CORRECT button is under my reply in main thread, not in email.