2 Replies Latest reply on Feb 9, 2017 10:46 PM by Norbert Maijoor

    More Dynamic LODs depending on granularity needed

    Adam Ehrenworth

      I have set up LODs that do a calculation by unique User ID but the current approach is a Year level.  If I want to be able to have a worksheet calculate if I want to do only a quarter of data or quarter verus quarter comparison would I need to set up a completely different set of LODs?


      This is how the one of the current LODs is set up.


      {Fixed[User ID], [Year]: SUM([OP_Manual_Entry_LaterFound])/SUM([Is Open Payments Reportable])}


      And the other one


      {Fixed[User ID], [Year]: COUNT([Open Payments Reportable Flag])}


      Can I do it with a parameter to adjust the LOD?