Ticket #30135
Question
I am having an issue with a Period Analysis report where I have 2 fields I wanted to compare for a specific time period, usually year over year. When I compare two years in the report, the revenue field in my report does not compare (there's no prior and current columns). Why is this?
Answer
Customer's "revenue" field was actually a calculation, and more specifically the calculation had been created as a calculation type 'Application'. Informed customer the Period Analysis feature in Reports is designed to work with type 'Database' calculations. Instructed him to recreate the calculation as a 'Database' calculation. Once done and he recompiled his report, this resolved his issue.
Asked on March 18, 2020