Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Sum(Sales)/Sum(TOTAL<Year> Sales/100 )
Hi Villyee,
A quick question, are you looking to calculate the % within script or front end?
I am trying it at object level, means at front end lwvel.
Hi,
Try with Sum(Sales)/Sum(TOTAL<Year> Sales)
Saludos
Sum(Sales)/Sum(TOTAL<Year> Sales/100 )
I've got following
=Sum(Sales)/Aggr(Sum({<Year>} Sales), Year)
but I'm missing rows
Sunny stalwar1 or others can help here.
May be this
=Sum(Sales)/Aggr(NODISTINCT Sum({<Year>} Sales), Year)
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
Yup
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