Aggregate Financials
Aggregate Financials (sum, last...) to Q end, HY end (Jun/Dec or Mar/Sep), and Y end (Mar/Jun/Sep/Dec).
Input Parameters/Data
To: Aggregate to Quarterly, Half Yearly or Yearly.
By: Aggregate by Sum, Minimum, Maximum, Range, First or Last.
Half Year End: Could be Mar/Sep or Jun/Dec.
Full Year End: Could be Mar, Jun, Sep or Dec.
Data Input: Row(s) and column(s) of data.
Notes
Unused rows are hidden (from bottom). Rows without labels are ignored.
Unused columns are hidden (from right). Columns without dates are ignored.
Output
Data: Output of the aggregated financials.
View demo here
Learn the basics in 5 minutes with our Quick Start Guide. To make the most of Fontics, check out our Tips & Tricks.