Calculate %

[vanderson009]

I have below formatted data and i want to percentage that are based on year.

Example - ProductA contribution in 2016 is 20 and percentage of contribution would be 33.33 % for that year.

Thanks,

Villyee.

[adityaakshaya]

Hi Villyee,

A quick question, are you looking to calculate the % within script  or front end?

[vanderson009]

I am trying it at object level, means at front end lwvel.

[fvelascog72]

Hi,

Try with Sum(Sales)/Sum(TOTAL<Year> Sales)

Saludos

[isingh30 · Accepted solution]

Sum(Sales)/Sum(TOTAL<Year> Sales/100 )

[vvira1316]

I've got following

=Sum(Sales)/Aggr(Sum({<Year>} Sales), Year)

but I'm missing rows

Sunny stalwar1‌ or others can help here.

[sunny_talwar]

May be this

=Sum(Sales)/Aggr(NODISTINCT Sum({<Year>} Sales), Year)

[vvira1316]

Yeah, that is correct. But the simple one mentioned by Ishtdeep will work.

I was having challenge as below

=Sum(Sales)/Sum( Total {<Year>} Sales) The curly braces for year were causing whole set sum. I didn't realize that curly braces for year were not required only angular were needed

[sunny_talwar]

Yup

[sunny_talwar]

Actually fvelascog72‌ was the first one to propose it and personally I would not multiply by 100 , but rather use number tab to show the expression as percentage