14 Replies Latest reply on Nov 18, 2013 9:09 AM by Jim Lynch

    Difference between columns in the same pane

    Cole Pacak

      I'd like to add a calucation that will show the difference between the two bars in each pane (orange minus blue). The field is called [LEP], and the two aliases are "LEP" and "Non-LEP".

       

      I already tried the calculation below but with no luck.

       

      IF ATTR([LEP])="Non-LEP" THEN

          LOOKUP([%_70_&_Above],0) - ZN(LOOKUP(ZN([%_70_&_Above]),-1))

      END

       

      It's possible that this formula IS correct but that I need to make an adjustment elsewhere.

       

      Any help would be really appreciated.

       

      tab quest -DELETE.png