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.

[Marc_Dillon · Accepted solution]

Nope, there's no variable assignment capability like that. Just keep doing it the way that you're doing it.

[feenyjamie]

Ok thanks.  Appreciate the response, Marc