This content has been marked as final.
Show 2 replies
-
1. Re: Level of detail expressions cannot contain table calculations or the attr function
Aditya Singh Dec 3, 2018 1:01 AM (in response to Divya Bhati)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 DehnerDec 3, 2018 5:23 AM (in response to Divya Bhati)
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.