Skip to Content
avatar image
Former Member

Help with Macro

Hi all,

I am trying to get zero values in a key figure row. It works fine as long as there is some value in the cells. When it is blank cell it doesn't show up zero there.

Any suggestions?

Thanks

Vard

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 09, 2008 at 07:25 PM

    Hi Vardev,

    I am hoping you are using the macro logic correclty.

    here is how I would do:

    If KFF1 is my KF then my macro would be

    Macro

    -


    Step

    -


    Row: KFF1=

    -


    0

    If the cell is a null value and if the system is not replacing it with zero, then cheange your macro like this:

    Macro

    -


    Step

    -


    Row: KFF1=

    -


    0

    -


    If

    -


    Condition (if Null)

    -


    IS_INITIAL(KFF1) = 1

    -


    Row: KFF1=

    -


    0

    -


    Endif

    If the system is not replacing all values with null and you want a zero in that, check in your planning area if "Zeros allowed" is checked for that keyfigure.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded