Skip to Content
avatar image
Former Member

Macro question

Greeting all

does any body know how can we force the keyfigure (by macro/ or any other function/methods) to view no value for the aggregated level of data while these records have data (in each line level)

it is similar to the safety stock key figure... if some body pull the data for group of products.. the safety stock Kf shows no value. however.. when you pull it for only 1 product it shows values

any idea how to do that?

Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 12, 2013 at 05:20 PM

    Hi,

    you can't, liveCache will always show you the sum.

    Possible workarounds would be (if we are talking about DP)

    1- use a foreground color equal to background color, so you see nothing

    2- hide the row, using ROW_VISIBLE(0), and detecting your aggregation level with AGG_LEVEL / DET_LEVEL, etc... inside your macro logic. If you are aggregating, hide, else show (something like that)

    If your problem is in SNP, you can hide your keyfigure if ACT_PRODUCT='' (meaning you have more than one product, eventually doing the same with ACT_LOCATION if needed). If you don't want to hide it, create a new one with similar name and copy your keyfigure with an automatic macro ONLY if you are not aggregating, then just hide your original keyfigure.

    hope this helps, I can try to write this more clearly tomorrow 😊

    J.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 12, 2013 at 05:53 PM

    Hello Areege,

    I am fully agree with James remarks. It's not possible to force zero or null value to aggregated values as the Live cache always displays the sum of all the products at the aggregated level.

    But I am glad to see the workaround suggested by James 😊

    Regards,

    Anurag

    Add comment
    10|10000 characters needed characters exceeded