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!

I was about to suggest the perspective thing, @Samir Banker, but now I'm out of options.

Maybe @Jenny Franklin can think of something...

Thanks Guillermo!  Yep, when I first saw the issue, I thought the same thing... since then we tried rebuilding the table, making new perspectives for every single column, and still no luck.  Appreciate the support though  :)

Have you also tried instead using a calculated metric instead of a perspective?  Ensure that the Summable box is checked for the calculated metric, too.

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.