09-12-2022 02:49 PM - last edited on 05-24-2023 12:21 PM by JackLacava
In my screenshot above, I would like to add a $ sign. I know this is done under Number Format. However I would like the $ sign to be aligned to the left-hand side. Would adding a narrow column allow me to do that? Not every line will have a $ sign attached to it.
09-13-2022 06:21 AM
Yes, you can add a dollar sign by adding another thin column. Here's the steps I'd recommend:
In your dimension library, create a UD member. I will use UD4, for this example.
If api.View.IsAnnotationType() Then
Return "$"
End If
Next, in your cube view design, add your thin column of AcctUnits values:
Note: the above dynamic calc formula will result in a [blank] when referring to other dynamic accounts, as shown in the last row of the report above.
Finally, you could duplicate this entire process to create two UD4 members, 'AcctUnitsLeft' and 'AcctUnitsRight' if you wanted to put $ signs on the left and % signs on the right.