Balance Sheet & Last Year

[kevbrown]

Please find attached sample QVW.

I'm trying to create the sum for "Balance as at last year", depending on which As At date has been selected. I'm sure it's easy

Kev

[stigchel · Accepted solution]

You can use the AddYears function and also better to use set analysis instead of if like this:

=sum({<[As At]={'$(=AddYears([As At],-1))'}>}Balance)

[kevbrown]

Superb, thank you

[stigchel]

You're welcome...

Maybe also add a e.g. Max to that expression for when nothing is selected:

=sum({<[As At]={'$(=AddYears(Max([As At]),-1))'}>}Balance)