My result is 2x what it should be because it's somehow including that column itself (the total column).
Yet if I wrap it in ( )/2 I get a different result that is not correct.
However if I add another expression as =TOTAL //the name of the total column it works.
I can hide the TOTAL column on the presentation tab so I have a work around so far.
Just not sure how I am going to get the average.
When looking at my table below keep in mind this is just what our data set contains the months could be This month (Feb 2017) going back 24 months. Notice how the first Total column is 2x what it should be. That's the one that says =alt(column(1),0) + alt(column(2),0) .... The second Total column says =Total which matches the name of the previous column. Very odd.
I need to calculate the final balance based on Min Year start and Max Year start . the date format is in the MMM-YYYY form. I'm writing the below syntax. I know somewhere is wrong. can you please guide me in writing the new syntax.
You could do it in the script by using the following way:
LOAD A, B, C, Num#(A ,'##.###') + Num#(B ,'##.###') + Num#(C ,'##.###') as D
(ooxml, embedded labels, table is sheet1);
This will sum the elements in each row of A, B, and C and will put it into D for you! Then you could use from "New object Sheet" --> "Table Box" to show your A, B, C, and D columns.