5 Replies Latest reply on Aug 16, 2018 1:54 PM by Deepak Rai

    % Difference from LODs

    Alex Braga

      Hi all,

       

      I have the following view below and the following LOD calculations.

       

      ALLOWED = {fixed DATETRUNC('year',[Svcbegdate]), [Lob Use], [Vendor Name], [Paytocgvrtin], [Servicingcgvrnpi]: sum([Allowed])}

      MODELED_ALLOWED = {fixed DATETRUNC('year',[Svcbegdate]), [Lob Use], [Vendor Name], [Paytocgvrtin], [Servicingcgvrnpi]: sum([STEP5_Contracted Global and Carveout])}

      DIFFERENCE = MODELED_ALLOWED - ALLOWED

      %_DIFFERENCE = DIFFERENCE / ALLOWED

       

      The %_DIFFERENCE results are wrong. Example, for COMMERCIAL 2017, the %_DIFFERENCE should be 2920.98/35642.15 = 8.1%, but it's showing 41.35%.

       

      What I am missing here? What can I do to fix the %_DIFFERENCE variable?

       

      Your help is appreciated. Thanks,

       

      Alex