Skip to Content
avatar image
Former Member

Macro to Zero Neg Sales

Hello Experts,

I have a requirement to change a Key figure value if negative to zero , else same value to be retained.

I tried writing a macro but failing due to syntax error.

Please let me know if any Macro expert can help me.

TIA

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 10, 2017 at 07:38 AM

    Hello,

    I am not an expert, but I have a similar macro. Please see screenshot attached. If you have doubts let me know.

    Regards
    harald

    screenshot-macro-negative-check.jpg

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2017 at 05:13 AM

    Hi,

    Please share screenshot of your macro and the syntax error you get.

    Best Regards,
    Ada

    Add comment
    10|10000 characters needed characters exceeded