Expression help

[#1]

HI All

i want sum the Sales for year = 2015 only

i don't have an year field only month Year field

like this

Jan 2015

Feb 2015

Mar 2015

Apr 2015

i want to fit this month year field  into this expression

sum({1<[Year] = {'2015'}>}Sales)

Please Suggest

[Mark_Little]

HI,

Add it to your script.

Right(Date,4) as Year

The you can use in the expression.

Mark

[sunny_talwar]

Try this:

Sum({1<MonthYear = {"$(='>=' & MonthName(YearStart(Max(MonthYear))) & '<=' & MonthName(Max(MonthYear)))"}>}Sales)

Where MonthYear is created in the script using MonthName() function.

[#4]

HI Mark

sorry For not mentioning

I want this to done on the table

I dont want this change in script

[roger_stone]

You can try this, it doesn't need to be in the script:

=SUM(IF (RIGHT(Year,4)='2015',Sales))

[sivarajs]

Do Subfield(MonthYear,' ',2) as Year in load then use the sum expression

[roger_stone]

The original poster has already said it can't be in the script.

[settu_periasamy · Accepted solution]

May be this

=Sum ({1<MonthYearField={"*2015"}>}Sales)

[thakkarrahul01]

Hi John,

you may find this link helpful.

Range of month in a bar chart