Template variables for long SELECT statements

[feenyjamie]

Hi all!

I'm creating reports on my personal Expenses app (balancing cash expenses with my partner) and I am able to produce things like "Current Balance" or "Current Balance by Month" using SELECT statements.

The problems is the template is about 6 pages long because instead of being able to assign a calculation result to a variable and then reuse the variable (on a global level, not row specific), I have to include each specific statement as I go deeper and deeper in the data.

For example, the picture below is actually only 5 lines on my report and is twice as long as the photo.  Most of the information is just SELECT statements reused.

Any ideas?

I would love to be able to assign these formulas to a reusable variable.