Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having trouble with totals. I have managed to get the correct total in a stragit table by using the Sum of Rows. However I want to repeat this total in a text box but I can only get the total that the straight table displays when expression total is selected.
I guess the sum of rows is doing something that I am missing from my formula in my text box.
=if(sum([Local Line Total Amount]=0),sum([Local Budget Amount]),sum([Local Item Extended Price])) this keeps giving me 6785530 but I know it should be 3210890
This is the table with totals at the top. Clearly the first column is totalled incorrectly and the second is correct but my formula gives me the first total.
6785530 | 3210890 | |
10 | 15000 | 15000 |
18 | 210000 | 210000 |
32 | 2000000 | 2000000 |
51 | 100000 | 100000 |
52 | 155100 | 155100 |
65 | 44000 | 44000 |
72 | 200000 | 200000 |
76 | 41718 | 41718 |
78 | 27812 | 27812 |
86 | 2560 | 2560 |
89 | 45000 | 45000 |
90 | 61000 | 61000 |
91 | 84000 | 28000 |
92 | 30000 | 30000 |
94 | 40000 | 20000 |
106 | 67500 | 67500 |
107 | 208000 | 100000 |
108 | 12000 | 12000 |
118 | 2300 | 1200 |
119 | 50000 | 50000 |
Any ideas? Please.
Thanks in advance.
Thanks, this works perfectly.
Thanks for the reply - whilst you may well be correct about the data model the aggr function seems to have fixed my issue so I won't go looking for trouble by re-examing the data model.
Thanks for the reply - whilst you may well be correct about the data model the aggr function seems to have fixed my issue so I won't go looking for trouble by re-examing the data model.