There is a very special way you have to make a perspective to do a ALL_ROWS that will include rows from the prior year, however, there is a new project setting that should just handle all of this automatically. I would suggest first trying this setting, and then seeing if it resolves your issue. This setting wil make it so you no longer need to think about or worry about ALL_ROWS, the system will determine a time spanning calculation is occurring and handle it automatically.
If this setting doesn't resolve the issue, then it is most likely a data issue where something is going to Various across time with respect to the identifier, the typical solution for this is to ensure all the columns in your groupby statement are included in your object identifiers.
If you can't get it sorted, please raise a support ticket, and follow up with me on the details.
Original Message:
Sent: 01-31-2024 19:19
From: Samir Banker
Subject: Not seeing all rows in time-based query
Hi Everyone, I am running into an issue and hope the community may be able to help.
We created a custom report in CT, which displays applications and their total annual cost for the previous year. However, I believe some rows may be missing in the table, as the total does not add up correctly. Meaning, if I export the table to excel and sum the cost column, it does not add up to the value displayed in the total. I have seen this in the past and was able to resolve by utilizing a perspective with the "show all rows in a time-based query" option selected. However, I have tried this here and I am still seeing the issue. Any ideas on things we should consider or possibly try ?
Thank you!
#CostingStandard(CT-Foundation)