Suppress the unit of measure (EA) from appearing on each line of a query.

[Former Member]

Hello and Happy new year.

How can you suppress the unit of measure (e.g. EA for a material) from appearing on each line of a query output?

Many thanks.

[former_member189638 · Accepted solution]

Use the Data Function NODIM in teh formula Key Fig

[Former Member]

Hi all,

I'm facing same problem. Actually I know that we can use NODIM function. However, we have many queries already, so in order to save time, we might do some macro to change the format, hiding the UoM. Is there anyone, who can give me some hints?

Thanks

Regards,

Anzar

[Former Member]

There is also another way to hide the UoM wihich doesn't require a fornula being created for each Key Figure. In the query properties click display scaling factors, it then moves the unit to the column header - provided the units are common. You would have to do this for each query but it may be quicker than using NODIM or writing macros.

Regards,

Matt

[Former Member]

Hi Matt,

You're right, we can use that option. However, as you said, if row/column contains same UoM. My reports are quite complex, they contains different UoM.

Regards,

Anzar

Edited by: Anzar Pradityo on Jan 10, 2008 12:49 PM