Reports - advanced formula output options

Matt Taylor

June 20, 2023 15:46 Edited

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.

3

• 

  Robin Van Brunt

  June 20, 2023 15:43

  I agree that being able to have this type of formula would be very helpful. 

  1

Please sign in to leave a comment.