-
1. Re: Level of detail expressions cannot contain table calculations or the attr function
Try to calculate the count/ total separately and then use that in if condition.
-
2. Re: Level of detail expressions cannot contain table calculations or the attr function
Jim Dehner
Dec 3, 2018 5:23 AM
Good morning
here is what is goin on
Total() is a table - you can replace Total with another LOD expression - without seeing the TWBX workbook to understand exactly what you are doing I would suggest you try - you will also want include th region in the numerator and the expression should be aggregated
if attr([Region])='Central' OR attr([Region])='East' then
sum({ FIXED [region] :COUNT([Customer Name])}/sum({ FIXED :COUNT([Customer Name])}
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.