on 04-23-2014 9:44 PM
We have a query with one of the attribute called "Previous salary" of EMPLOYEE displayed in the format of "USD 234,100.00", but users want onlu numbers (234,100) without USD. How to remove USD from the value displayed from an attribute. I couldn't use NODIM becasue it's not a key figure? Thanks.
Hello B Z,
Rajesh first option is right . You can use a Formula Variable with replacement path. And in the replacement path of this formula variable you can select attributes as shown below . In this example i have shown Customers attributes . And then apply a nodim on this formula variable.
Regards,
Ashutosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try to use the scaling factor display options in run time.
Go to Query properties -- > Display Options --- > check the display scaling factors.
If you enable this option currency will be displayed with scaling factor only and result value will show as without currency. Please find the below example.
Ex:
Country Price Sales Revenue
USD 10USD 100 200 50
( scaling factor)
Regards
Malyadri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do not "Display Scaling Factors" for your KF in query. Then USD will appear in KF heading.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi BZ,
Can you try with RKF and CKF use data fuction in CKF Left or Right etc..
try this.
Hope it will helpful.
Regards,
Ganesh Bothe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi BZ,
1) You can use the forumula using replacement path varaible to read the attributes of the master data ( Key figure).. Then you keep a NODIM for that keyfigure. That should solve the problem.
2 ) if you have BO team ,ask them to remove it otherwise.
Option 1 will work for Bex.
Regards,
Rajesh
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.