Reports - advanced formula output options

Follow

Matt Taylor

June 13, 2023 14:32

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.

1

• 

  Robin Van Brunt June 20, 2023 15:43

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

  1

  Comment actions Permalink

Please sign in to leave a comment.