8 Replies Latest reply on Jul 7, 2017 3:53 AM by T G

# percentage

Hi Guys

How do I show % diff in the label, as you can see I have calculated the difference. Cant figure this out...

• ###### 1. Re: percentage

Hello Junaid,

Are you looking for this below view. If yes, you just need to drag %score to label tab as DifferenceREVERSE.

TG

• ###### 2. Re: percentage

Did you try add a quick table calc on DifferenceReverse, is that what you want?

• ###### 3. Re: percentage

Hi TG

Thanks for taking time to reply. Not quite what i need is as you can see the difference for Jan is -3,227,481. I would like to divide this by the Base number (Capclean which is the highest number 10,025,305 for January)

-3,227,481/10,025,306= -0.321 * 100= - 32.1%

Is this possible?

• ###### 4. Re: percentage

Hi Mihai

Thanks for taking time to reply. Not quite what i need is as you can see the difference for Jan is -3,227,481. I would like to divide this by the Base number (Capclean which is the highest number 10,025,305 for January)

-3,227,481/10,025,306= -0.321 * 100= - 32.1%

Is this possible?

• ###### 5. Re: percentage

Use LODs Difference/{FIXED Month(Date) : Max(Capclean)}

• ###### 6. Re: percentage

Hi Zunaid,

Do you want result as below

for this you need to make Calculation filed as below-

SUM([Difference])/SUM([Capclean])  & Drag it in Lables

If Still Stuck in between please let me know.

Thanks

ALOK

1 of 1 people found this helpful
• ###### 7. Re: percentage

Thanks Alok

• ###### 8. Re: percentage

Hello Alok,

You need to update your % calculation as SUM([DifferenceREVERSE])/SUM({FIXED [Valuation Date]:MAX([Capclean])}).

TG