How Do I Calculate Cumulative Data from the Start of a Report Rather Than The Start of an Organisation’s Data
Within a Report Card in Futrli, the date that cumulative data begins can be amended. By default, cumulative data will commence from the start of an Organisation’s data. This can be changed though to begin from specific dates that suit the Report in question.
Once a new Report Card has been opened and the correct Organisation has been selected, ensure that the Data Type is Actual or Forecast and Actual. The data range is specific to the Report timeframe, but will need to be set to one less period than required. For example, if the Report was to show the cumulative Income for the previous 6 months, the date range will be This (or Last) calendar month, & the previous 5 Periods:
In the Report section of the card you can change the account you want the card to report on, but you can also change the way it displays this data, and whether you want it to be transactional or culmulative:
If you select cumulative you will be presented with a further drop-down which will give you option to cumulate from the start of this report:
This will ensure that the data begins from the start date of the Report, rather than the start of the Organisation’s data: