Categories
Custom field calculations at total level
NA version, CLOUD: Reporting / Dashboards
ACTUAL BEHAVIOR
--------------
When creating a custom column defined as "Units"."Remaining Units"/"Units"."Limit" the summary has no value.
EXPECTED BEHAVIOR
-----------------------
The field summary should not display as null.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new analysis in the Primavera - Role Utilization subject area
2. Create a custom column defined as "Units"."Remaining Units"/"Units"."Limit"
We are told that this functionality is currently not possible within OBIEE because at the summary level in a pivot table there is not a way for it to use a formula.
We were asked to make a post here asking to see if there was a workaround anyone knew of.
Answers
-
Hi @User_H0QFW
Welcomed to the community, please update your profile, so we know with whom we are communicating with.What exact product are you talking about? I see Primavera mentioned, as well as OBIEE, and the tag says OAC. Which one is it?
Since you seem to be posting a "service request" you received from somewhere it may be helpful if you explained in more detail what you are trying to achieve (not the technical implementation you've already pre-chosen) and what outcome you expect.
1