Forum Discussion
CubeValue formula to data model - only works partially
Kiwi_911
The actual formula has an IFERROR surrounding the CUBEVALUE formula; it returns 0 if the CUBEVALUE formula evaluation returns an error.
Therefore, in the report the 0-values might correspond to errors in the CUBEVALUE calculations.
Please try evaluating it without the IFERROR and try to debug if there are errors; please check if you have in Measures the corresponding formulas for each Organizational Unit (and that they work with the "Summe von "&OrganizationUnitName).
If this does not work please share the formulas you have in [Measures] so we can try to find if there are some issues there.
Super UserKiwi_911
The actual formula has an IFERROR surrounding the CUBEVALUE formula; it returns 0 if the CUBEVALUE formula evaluation returns an error.
Therefore, in the report the 0-values might correspond to errors in the CUBEVALUE calculations.
Please try evaluating it without the IFERROR and try to debug if there are errors; please check if you have in Measures the corresponding formulas for each Organizational Unit (and that they work with the "Summe von "&OrganizationUnitName).
If this does not work please share the formulas you have in [Measures] so we can try to find if there are some issues there.
Hello pcoley, thanks for your help. Yes, the error is caused by the CUBEVALUE formular. I can try without the IFERROR and its the same result. But based on your hint, I checked the concatenation "Summe von "&OrganizationUnitName and changed it. And YES, it works.
changed formulaformer formula
