I'm looking to add a single field to a report that I don't want in either the rows or the columns. Idealy it would appear in the header, but I can't figure out how to put a formula in there.
What I want is to calculate the percentage left in the fiscal year. If we're in period 3 of the year, I simply want to enter the formula "periods/12" to show how far we are into the year. example: 3/12 = 25%
So in a budget report we would have the percentate used of a budget and the percentage of the year so far in comparison. I can do this in the column definitions, but is shows for every row of the report and makes it very messy.
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156