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

# % 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?

Alex

• ###### 1. Re: % Difference from LODs

DIFFERENCE = SUM(MODELED_ALLOWED) - SUM(ALLOWED)

%_DIFFERENCE = DIFFERENCE / SUM(ALLOWED)

• ###### 2. Re: % Difference from LODs

Hi Deepak,

thanks for the reply. Tableau doesn't like this:

DIFFERENCE = SUM(MODELED_ALLOWED) - SUM(ALLOWED).

The DIFFERENCE pill goes red (even tho this calculation is accepted) and the whole sheet goes blank.

I appreciate the help tho! Thanks,

Alex

• ###### 3. Re: % Difference from LODs

Pl keep Cursor over the Red and see what it is saying

• ###### 4. Re: % Difference from LODs

I'm getting the below. This red variable is basically: DIFFERENCE = SUM(MODELED_ALLOWED) - SUM(ALLOWED).

Thanks! Alex

• ###### 5. Re: % Difference from LODs

You have one of the calculation which is already aggregated. From this point, I would need a workbook to look into .

Thanks

Deepak