1 2 Previous Next 22 Replies Latest reply on Dec 24, 2015 11:53 PM by kri shna

    Educational Brain Teaser : Fun with Measure Value Formatting

    Rody Zakovich

      Hello Community!


      We haven't had a Brain Teaser posted in a while, so I thought I'd give it a shot. 


      The Goal.....Add a KPI indicator to [Difference] => ( ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1) ), for all relevant values, and a N/A for the first partition.


      10-9-2015 11-15-53 AM.png


      Note that [Difference] is a continuous measure....


      As always, please rate on a scale of 1 - 5.


      Best regards,



      Simon Runc want to kick things off?

        1 2 Previous Next