I see, makes sense now. Thanks Jeffrey.

Thanks, Jeffrey. I think I am following what you are doing here (remember, an SQL noob here). What is the 64 in set functions? Is it to assign 64 bits...

Thank you, Mr. Brian Gale. This helps puts things in perspective.

Thank you so much, I believe I get it now. Below is a simplistic example of what's happening.

Let's say this is our code.

SELECT
    ...

@Mr. Brian Gale, thank you so much!!!

Your last submission worked like a charm and per your recommendation I adopted it. However, I am wondering what really happened there because to...

Thank you Steve Jones for the comments, based on which I was able to find the solution.

This solution requires a lot of manual work but basically you have to create...

I found my answer by looking at this video: https://www.youtube.com/watch?v=Zebwsa-3QZQ&list=PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU&index=44

Solution:

• Function could not be a calculated field but a column with expression.
• On non-aggregate rows needed to use...

Hi,

Can you please elaborate? When you say nothing happened - as in, you saw the proper percentages as shown in picture 2 red and green text?

If so, which formula did...

Sad bump, no one knows 🙁

Yup, I think we are talking the same approach now. I was hoping there was an easier way but looks like making separate tables and stitching them together is going...

And probably use Sum (IF ... + Sum (IF ... to get Total Revenue Budget, Total Revenue Encumbrance etc.

Likewise Sum (IF ... - Sum (IF ... to get Operating Net...

Thank you so much. This gave me the idea to group these appropriately by creating another field called Account Group and using your logic (IIF AND and IIF OR statements)...