Wrap the last part with an ATTR()
ELSEIF ATTR([Expired Member]) = 'Expired' then .....
All parts of the IF/THEN should either be an aggregate or not, you can't mix the 2.
Hope that helps!
Hard to understand the underlying cause of that without seeing or being able to interact with the data. Are you able to attach the workbook?
I would like to but due to my organization rules and policies, its difficult to upload the workbook..
I used the following and it is working
IF [Metric to View] = 'Members Acquired' then [Total Members]
ELSEIF [Metric to View] = 'Acquisition Rate' then [AQRate (copy 2)]
ELSEIF [Metric to View] = 'Live Member Group' then [Total Members]
ELSEIF [Metric to View] = 'Loyalty Sales' then [Nett]
ELSEIF [Metric to View] = 'Member Frequency' then [FRE_TRND_AllMembers (copy)]
ELSEIF [Metric to View] = 'Member Ticket Average' then [TA_Members (copy)]
ELSEIF [Metric to View] = 'Member Points' then [Points]
ELSEIF [Metric to View] = 'Expired Members' AND [Expired members] = "Expired" then [Total Members]
Thanks a lot for the help!
I just changed the calculated fields like TA_Mmebers, AQRate which were aggregated to non-aggregated ones. and applied the logic in the previous message.
Awesome! Glad you got it to work.
I will make sure to attach a sample workbook next time so that it becomes easy to communicate!