Using Set Analysis with Text

[sagar_vij99]

Hi All,

I am trying to use below expression with set but somehow it is not working.

here i am trying to sum Headcount field value and i need to get the value for last month.

=sum({$<P_Month={"=Date(AddMonths(today(),-1),'MMMM')"}>}Headcount)

any help will be appreciated.

Regards

Sagar

[MayilVahanan]

Hi

Is it P_Month format correct?

Edit: Missed $ dollar.

=sum({$<MonthYear={"$(=Date(AddMonths(today(),-1),'MMM'))"}>}Headcount)

or

=sum({$<MonthYear={"$(=Month(AddMonths(today(),-1)))"}>}Headcount)

[Chanty4u]

Try:

=sum({$<P_Month={"$(=month(addmonths(today(),-1)),'MMMM')"}>}Headcount)

[Anil_Babu_Samineni]

Chanty,

How come Month() applies MMMM. Use Date()

[neha_shirsath]

What is the date format of P_month?

try this-

sum({$<[Month Name]={"$(=Monthname(addmonths(today(),-1)))"}>}Value)

[sunny_talwar]

May be this

=Sum({$<P_Month={"=Only({1}P_Month) = MonthStart(Today(),-1)"}>} Headcount)

or

=Sum({$<P_Month={"$(=Month(MonthStart(Today(),-1)))"}>} Headcount)

[sagar_vij99]

Ohh yes i missed the $ sign,, Thanks for the reply.

Just for better understanding when we use formulas in set analysis then we have to use $ sign. What it actually indicates while execution..??

[sunny_talwar]

Check this link out

The Magic of Dollar Expansions