Reports - advanced formula output options
ADM's reporting tool allows you to add a formula column using the advanced button at the bottom of the 'output' page, but currently the functionality is limited to basic math and numerical outputs.
We have several scheduled reports which we currently have to export as a CSV, apply a formula to a column (such as '=TODAY()+3' to indicate a delivery date, or taking the event start date from ADM and adding -7 to ensure delivery of materials 7 days before) which, if more advanced options were available, could be completely automated.
This may sound minor, but this would save many hours work every week, unecessary manual data handling and avoid any human error occuring when doing so.
Please sign in to leave a comment.