Valitse organisaatio
Error "Level of detail expressions cannot contain table calculations or the ATTR function" Occurs in the Calculation
Julkaisupäivä: Apr 25, 2025
Kuvaus
If you use LOD (level of detail expressions) with table calculation or ATTR function, the below error will occur and you cannot finish the calculation.
Level of detail expressions cannot contain table calculations or the ATTR function
LOD with table calculation:
LOD with ATTR function:
Cause
This is by design.Ratkaisu
For table calculation
Option 1:
Only use the table calculation and set the computing dimension.
For example, if you want to calculate the rank within each category, please refer to the below image.
Option 2:
Move the Table Calculation outside of LOD expressions like the below image.
Note: please verify if LOD expression is necessary or not.
For ATTR function
Replace the ATTR function with MIN() or MAX() function or rewrite the aggregation function within the LOD expression like the image below.
Please also refer to the attached workbook for details.
Knowledge-artikkelin numero
001496829
Ratkaisiko tämä artikkeli ongelmasi?
Anna palautetta, jotta voimme kehittyä!
