Skip to Content
avatar image
Former Member

Add unit to key figure in Query Designer

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 24, 2008 at 11:39 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2008 at 11:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded