Discussions
Substituting Field Values for Reporting (Expense Receipts)
I am curious if anyone knows of a way to substitute field values for reporting purposes. A specific example is the "Missing Paper Receipt" flag for an expense receipt. The expense report will list out either "Yes" or "No" for any given receipt.* However, for improved readability, especially for our accounting department when doing report audits, it would be useful to substitute "Yes" in that field with an "X", and substitute a "No" with just a blank.* I would also like to do this for the "Billable" flag - substituting some other value for "Yes" and blanking out the "No."*