satyakumar
Programmer
Hi Folks,
I want to calculate % of a column based on the Running totals.
-------------------------------------------------------------
I have a group in a report which is a formula called @Type.
So @Type Group returns date like this.
YEAR-2012
---------
Intra
-----
ABCD 500
CDEF 1500
EFGH 1000
-------
Total: 3000
-------
Extra
-----
AEDD 1500
DFDD 500
GDSD 500
-------
Total: 2500
-------
-------
Tot Intr + Tot Extra: 5500
-------
Inexta
-----
HJHK 100
YTYT 1500
YUYY 1000
-------
Total: 2600
-------
So in the above report i want to calculate the % column of YEAR 2012. So my formulae is
YEAR 2012/(Tot Intr + Tot Extra) *100
So howdo i calculate the formulae.
Right now i am using Running total to get the (Tot Intr + Tot Extra) in the Report. But when i add running total in the formualae its not calcluating correctly.
Note: I can do like this YEAR 2012/sum(YEAR 2012) *100
But i dont want to add Inexta total in the % calculations.
Please help me in resolving this issue.
Thanks
Satya
I want to calculate % of a column based on the Running totals.
-------------------------------------------------------------
I have a group in a report which is a formula called @Type.
So @Type Group returns date like this.
YEAR-2012
---------
Intra
-----
ABCD 500
CDEF 1500
EFGH 1000
-------
Total: 3000
-------
Extra
-----
AEDD 1500
DFDD 500
GDSD 500
-------
Total: 2500
-------
-------
Tot Intr + Tot Extra: 5500
-------
Inexta
-----
HJHK 100
YTYT 1500
YUYY 1000
-------
Total: 2600
-------
So in the above report i want to calculate the % column of YEAR 2012. So my formulae is
YEAR 2012/(Tot Intr + Tot Extra) *100
So howdo i calculate the formulae.
Right now i am using Running total to get the (Tot Intr + Tot Extra) in the Report. But when i add running total in the formualae its not calcluating correctly.
Note: I can do like this YEAR 2012/sum(YEAR 2012) *100
But i dont want to add Inexta total in the % calculations.
Please help me in resolving this issue.
Thanks
Satya