on 11-02-2007 6:58 AM
Hello, everybody!
I have a query. And it has a row which contains unit of measure. So I need to suppress unit of measure in data cells. How can I do this in BEx Analyzer 710?
I've found the following feature.
If the query property "show scaling factors for key figures" is set then query is shown with additional row where the scaling factor and unit of measure are placed. Then I can hide this row by excel features.
Now it is the most applicable solution I've known.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks!
But I forgot to mention my query is input ready and it should allow to enter data. So formula with NODIM function doesn't apply for my case.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create a new formula for your quantity KF and use NODIM function in it. Display this new formula instead of of your original KF. It will show only the value without any units. Hope this helps.
regards,
Sumit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use NODIM function to suppress units in the formula.
Formulae - >NODIM ( KEYFIGURE or Calculation )
Message was edited by:
Jr Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.