Add unit to key figure in Query Designer

[MichaelHartung]

Hi all,

in a calculated key figure I have a key figure with a unit (pc) that I want to add to another key figure that does not have a unit . The result is * of course.

I tried adding the unit to the calculated key figure, also tried a restricted key figure using the key figure without unit but the result is the same.

How can I add the unit 'pc' to my key figure to make it work?

Or even remove the unit from the other key figure as unit is not really important here?

Thanks and regards,

Michael

[Former Member · Accepted solution]

Use the NODIM() function on your key figure in Pcs, this removes the units. Then you can add both, or use nodim on the calculated kf.

[yogesh8984]

Hi,

Create one calculated KF using the function NODIM from the data functions in BEx. This will remove unit from the KF. But I am not sure whether it will allow you to add the value to other KF.

Please check.

Regards,

Yogesh