Hello.
I have a report based on a query with caluclations etc to create a 30yr forecast.
There are fields which are required for the calculations but not to be seen on the report. Ok this is ok upto here, however one of the fields means another field has more than one of the same. i.e duplication. This is shown on the report. Under "Neighbourhood" is there a way to group these together. If i remove the field creating these duplications my caluclations dont work and the report says cannot find expression etc.
Please refer to pic for more info.
Any help much appreciated.
I have a report based on a query with caluclations etc to create a 30yr forecast.
There are fields which are required for the calculations but not to be seen on the report. Ok this is ok upto here, however one of the fields means another field has more than one of the same. i.e duplication. This is shown on the report. Under "Neighbourhood" is there a way to group these together. If i remove the field creating these duplications my caluclations dont work and the report says cannot find expression etc.
Please refer to pic for more info.
Any help much appreciated.
