Export: line per REPORT, not per EXPENSE

jms

I'm trying to create reports about reports, not the individual line items. Even if I only use report: tags, it appears that I get all expense rows. Is there a way to get one row per report on export? Something of a GROUP BY?

Isabela Stisser

Hey @jms, thanks for posting to the Community! Please take a look at this article for more information about report level formulas.

Let me know if you have any questions, and I will be happy to help!

jms

I am only using {report:x} tags and I get a row output for every line item. 

April Bekkala

Hi @jms - There will be an entry for each expense located on the report. Once the report(s) are exported you can remove any rows that you find unnecessary. 

Jeremy Boniface

@jms
If you reach out via concierge@expensify.com, I can help you build a special template that will output one line per report. I'll just need the specification from you (which columns you need, etc) and an example report to test with. In your inquiry, note that Jeremy offered to build you an "IS template", and the request should be routed to me.