Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Try:
=sum({$<P_Month={"$(=month(addmonths(today(),-1)),'MMMM')"}>}Headcount)
Chanty,
How come Month() applies MMMM. Use Date()
What is the date format of P_month?
try this-
sum({$<[Month Name]={"$(=Monthname(addmonths(today(),-1)))"}>}Value)
May be this
=Sum({$<P_Month={"=Only({1}P_Month) = MonthStart(Today(),-1)"}>} Headcount)
or
=Sum({$<P_Month={"$(=Month(MonthStart(Today(),-1)))"}>} Headcount)
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..??
Check this link out