% Difference from LODs

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