if and abs div#/0!

  1. D

    ABS or IF statement

    or maybe both? I have hyperion linked data and i am doing % increase/decrease and when I have 0 sales units for 08 and 0 sales units for 09 im getting a -100% what I would like is to limit my downside variance to -100% and have the +variance unlimited; I have tried various min/max formulas to...

Some videos you may like

This Week's Hot Topics