2 Replies Latest reply on Jul 25, 2018 8:02 AM by Ankit Bansal

    LOD calculation help

    Mark Alvarado

      in the below view i need help with the SPL On % and SC On % calculations.  All fields not highlighted below are all LOD calculations.  For some reason the percent is super inflated.

       

      I have attached the extracted workbook.

       

      Thanks!

       

        • 1. Re: LOD calculation help
          Bryce Larsen

          Hi Mark,

          All you need to do is sum each before you to the rate:

          SUM([SPL On Count])/SUM([SPL Count])

           

          That should do it!

           

          • 2. Re: LOD calculation help
            Ankit Bansal

            Mark,

             

            I think something wrong in your LOD calculations:

            SPL count is:

             

            { FIXED [Store_ID],[Week End],[LOAD_NUMBER]:COUNTD(if [Actual Order Type]="SPLIT LOAD" THEN ([Store_ID])

            ELSE NULL end)}

             

            if you need distinct store_id count for a given week and load number you should not give store_id in fixed dimension. Can you change it to:

             

            { FIXED [Week End],[LOAD_NUMBER]:COUNTD(if [Actual Order Type]="SPLIT LOAD" THEN ([Store_ID])

            ELSE NULL end)}

             

            See if that works.

            1 of 1 people found this helpful