how to write a set expression for sales in current year and not in previous year?

[#1]

Hi All ,

how to write a set expression for sales in current year and not in previous year?

Thanks

John

[jonasheisterkam]

Hie hope this helps.

=Sum({<Year={'$(=year(Today()))'}>}Sales)

[Anonymous]

Hi,

Try:

=Sum({<Year={$(=Max(Year))}>} Sales )

or

=Sum({<Year={'$(=year(Today()))'}>}Sales)

or

=SUM({$<Date = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}Sales)

Regards

Neetha

[#4]

Thanks Neetha.

Can you please explain me, how this expression will check weather sales are present in previous year or not.

[simonc-cfn]

Hi John,

I believe the following set analysis expression may provide you with the results you seek.

sum({$<[Order Year] = p({$<[Order Year]={$(=max([Order Year]))}>}

[Order Year]) - p({$<[Order Year]={$(=max([Order Year])-1)}>}

[Order Year])>} Quantity)

Please note that the Max aggregation used is assuming that the max possible year is current year. Feel free to adjust as needed.

I hope this helps.

Simon

[Anonymous]

Hi,

Mistake,to check sales not in previous year,use below syntax:

=Sum({<Year={$(=Max(Year))},Year -= {'$(=Year(Today())-1)'}>} >} Sales )

or

=Sum({<Year={'$(=year(Today()))'},Year -= {'$(=Year(Today())-1)'}>} >}Sales)

or

=SUM({$<Date = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'},Year -= {'$(=Year(Today())-1)'}>} >}Sales)

Regards

Neetha

[#7]

Hi Simon Calzada

Can you Please Explain me How this P() function Works, if you provide any Detailed Doc on P()  it will be helpful for me .

Thanks

John

[jonasheisterkam]

P() selects all possible values of the field => white/green

E() selects all excluded values => grey

[engishfaque]

Dear John,

Here is an expression, please check.

Current Year Sales Expression:

=Sum ({$<Year = {$(=Only (Year))}>} Sales)

Kind regards

Ishfaque Ahmed

[#10]

Hi Jonas Heisterkamp,

Can you Please explain me with an example where it is useful, where can we use it.

Regards

John