Some help with set

[G_Hofstedt]

Hi

I have this expression. sum({<Month=, Year = {"$(#=max(Year))"}, MonthNr= {1,2,3,4,5,6} >} Sale)

Now I want to exclude some transactions that can be backdated. The transaction have a UTYP = 201 and INSDATE larger then Max(Year) Month 07 and Day 03.

How can I include that exclude-expression in the set?

[Anil_Babu_Samineni]

You can exclude like -= in your set analysis

I would ask you to create this statement in script, I assume INSDATE has Year Values if not you may create Year(INSDATE) as Year and then use Year direct rather INSDATE for condition

If(UTYP <> '201', If( INSDATE > Max(TOTAL Year), If( Month <> '07' , If(Day <> '03', 'Exclude', 'Include') as FieldName

And then some thing like this for set expression

sum({<Month=, Year = {"$(#=max(Year))"}, MonthNr= {1,2,3,4,5,6}, FieldName -= {'Exclude'} >} Sale)

[sunny_talwar]

You can also use e()

P() &amp; E() and where do you use them?