Trying to put Expressions into Variables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a number of expressions in my document that I am using repeatedly, so I wanted to load them into variables.

First I defined them in the document using the Variable Overview and that works perfectly.

Best practices recommends loading them in the script, so I attempted to do that, but have had no luck getting it to work.

This is what Variable Overview shows if I define it in the document:

eCurrentYear = sum({$<@Year={$(=(@Year))},@Quarter = ,@Period = ,@Week = >}#InvoiceTotal)

eLastYear = sum({$<@Year={$(=(@Year)-1)},@Quarter = ,@Period = ,@Week = >}#InvoiceTotal)

Life is good!

This is what Variable Overview shows if I define it in the script:

eCurrentYear = sum({$<@Year={(internal error)},@Quarter = ,@Period = ,@Week = >}#InvoiceTotal)

eLastYear = sum({$<@Year={(internal error)},@Quarter = ,@Period = ,@Week = >}#InvoiceTotal)

Does anybody have any idea what's causing the internal error, and how to get around it?

Re: Trying to put Expressions into Variables

Anonymous — Thu, 01 Feb 2018 12:33:06 GMT

Finally got it working, based on a previous post in the Community by Sunny Talwar.

LET etCurrentYear='sum({$' & '<@Year={$' & '(=(@Year))},@Quarter = ,@Period = ,@Week = >}#InvoiceTotal)' ;

LET eLastYear='sum({$' & '<@Year={$' & '(=(@Year)-1)},@Quarter = ,@Period = ,@Week = >}#InvoiceTotal@)' ;

I just needed the ' & ' after the $ signs. It now works as expected.