Hello! I have an issue regarding the account dimension and formulas within it. I have an account member that is meant to lookup a value from another account member. When I created the formula it worked in the preview but no matter what filters I set in the story the value of the account member unbooked and nothing appears. I changed the structure priority to the account dimension as well. I then changed it so that instead of using lookup I utilised RESTRICT() but it still did not work. I then found out that the IF statement i was using was preventing my script from functioning correctly But I need it in order to classify a dimension value.
As you can see the Account dimension i am trying to utilise is called Service Charges Per person(SC_PER_PERSON) and copy the values from service charges into the SC_PER_PERSON account member. But in the table only service charges show and SC_PER_PERSON will not appear as the table is set to booked only and there are no values in the member(I checked using unbooked)
Any help at all would Be greatly appreciated!
- SAP Managed Tags:
Accepted Solutions (0)
Answers (1)
Hi ahfadoo,
In the formula, you need to specify whether you want to filter by ID or Description.
Formula:
Output:
| User | Count |
|---|---|
| 78 | |
| 10 | |
| 10 | |
| 7 | |
| 7 | |
| 6 | |
| 6 | |
| 6 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.