cancel
Showing results for 
Search instead for 
Did you mean: 

Do not show unit of measure in cells.

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

You can use NODIM function to suppress units in the formula.

Formulae - >NODIM ( KEYFIGURE or Calculation )

Message was edited by:

Jr Roberto