Skip to Content
author's profile photo Former Member
Former Member

Key figure is displayed as 2.007 not 2007, any solution?

Dear Sirs,

I have a key figure called Year, of type Int 4. This is being filled from a day using the DATE_YEAR function in the update rule.

When it is displayed in Bex Web it is shown as 2. 007 (with a dot and a space). As far as I can see it also saved in this format in the actual data.

How can I display this as 2007 and not 2. 007 ?

I have tried different things, using the nodim() and the trunc() in the update rule. I have also tried to change the scaling factor in Bex Query designer on the key figure.

I am aware that changing the display format in SU3 could solve it, but I would like to solve it independant of the different users, and make it only valid for this key figure.

Can anyone help me?

best regards,

Jørgen Ruud

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 08, 2008 at 09:27 AM

    Did u try creating a a formula and multiplying the K.F with 1000???

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      this does not help, I have already trying to do this in the query. By changing the display (scaling factor) to eg. 1000 I can manage to display 2 (*1000) if the value is 2000.

      However no matter what the scaling factor is, I can't show 2. 007 as 2007


      Edited by: Jørgen Ruud on Jan 9, 2008 7:22 AM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.