Set Analysis with Conditional Selections

[#1]

I am trying to create an expression as follows :

sum({1<InvoiceDate = {"=($(vTodaysDate) - InvoiceDate)<366"}>} [LineSalesAmount]))

1. The expression should be independent of any selections. So I added sum({1 ....

2. But the issue is I have InvoiceDate inside the condition . So this condition is afffected by the selection

The question is how can I make the condition also independent of the selection

[d_pranskus]

Try to use following expression

SUM({1<InvoiceDate = {">=$(=DATE(TODAY()-366))<=$(=DATE(TODAY()))"}>} [LineSalesAmount])

This will sum all invoices in last 366 days.

The Number Format of the field InvoiceDate must be Date.