I'm trying to sum all the activity for a particular chosen financial year, but for some reason I can't get it to work. Here is the formula:
varFiscalYear is a variable that evaluates to 2016_17. The error message I get is "Error: Error in set modifier adhoc element list: ',' or ')' expected" but I'm not too sure what the issue is. Any help with this will be much appreciated.
...if I substitute the varFiscalYear for '2016_17' the formula seems to work. Here is the working formula:
Would declaring varFiscalYear as a variable and then using it in a formula be causing it any problems at all???
Yes, it seems as though your first formula has done what I have wanted! Brilliant - thank you very much for your responses, they've been much appreciated.