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))



      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