Custom formula in AO template

[former_member244687]

Hello All

I have report for comparison of Last year and Current year Plan data ( eg : Jan 20, Feb 01, Mar 20.. Vs Jan 21, Feb 21. Mar 21... ) . now the user needs total column of both previous and current year. I have just added up the Excel sum which I feel is not adequate as it is losing the formatting. The other option I was looking for was Calculate button in AO but I did not find in the Add option for totals. what are the ways of achieving the totals ?

[andrewdiaz2000 · Accepted solution]

Hi Raj,

Add two Lines and do the same. it should work. Make sure you do not give all columns in the formula.

Hope if it helps, Do mark it as helpful..!

[former_member244687 · Accepted solution]

Andrew , I have not given all the columns in the formula, but looks like it takes the entire row even though you select specific cells only. how can make the selection (like only for specific quarter ) ?