7 Replies Latest reply on Jan 21, 2019 12:10 PM by Joshua Preston

    Move Max LOD to correction field segment

    Joshua Preston

      Hello - I have an LOD that returns the max measure for the max year, but it ends up on the wrong line.

       

      It's fairly straightforward. Any ideas on how to get it to behave? thx. twbx 2018.3 attached.

       

      example: the .022 percent of workers should be on the "At Minimum Wage" line, not the "Below Minimum wage line"

       

      LOD:

       

      if { FIXED [State]:

      MAX({ FIXED [State],[Pay rate]: SUM([Pay Rate #])})}

       

      ={ FIXED [State],[Pay rate]: SUM([Pay Rate #])}

       

      THEN [Max Pay 2017] END