set analysis

[Krish2459_58]

Hi,

Help me to integrate this condtion in set analyis.

Condition : Max([Lease Expiration])-Now()<=360

Expression : sum(sales)

Thanks,

[Krish2459_58]

Any suggestions please.

[BrunPierre]

Have you already tried something like this?

=If(Floor(Max([Lease Expiration]) - Now()) <= 360, Sum(sales))

[Vegar]

How does your data look like. Donyou have [Lease Expiration] on transaktion lever? If so then you can do something like this:

Sum({<

[Lease Expiration]={"<=$(=360+Now())"}

>} Sales)

If you don't then you might need to tell us more about your datamodel and the relation between Sales transactions and the table holding the [Lease expiration] field and how which dimensions you have in your visualisation object (chart/table/kpi).