How to add Asset Category and Project Number to What-if Report?

Summary:

We are trying to add  Asset Category and Project Number to the code of the delivered What-if Report. Please see attached SQL.

We added a few joins, but the results are way off just running the What-if by itself.

Has anyone attempted this (in order to send future depreciation to your planning system)?

Any advice on better tables to join, or join a different way?

Thanks, Brad

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

see attachment