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.
