LOGIC Required

[abhaysingh]

i want to see my PROJECTED SALES for current Month ONLY when I select back Month or Years it should give me NOT APPLICABLE

Projected sales calculated as SUM(SALES)

kindly help

[Anonymous]

sum({$month=()sales})

i hope it works if not let me know

[PrashantSangle]

Hi,

Just write.

It will give you only current Month Sales

Sum({<Datefield={">=MonthStart(Today())"}>}Sales)

Regards,

[abhaysingh]

Not working

[abhaysingh]

this is my run Rate logic=

(NUM(sum([Prd. Value]) / vCrore  /  if(GetFieldSelections(FMonth)=month(today())
and GetFieldSelections (YEAR) ='14-15' , Day(date(today()) ), ((count(Days)))),'#.##') )

and I want it to run it for current month and year only when I will select back month it should give me NOT APPLICABLE

[er_mohit]

Try this

Sum( {<  Date={'>=$(=MonthStart(Max(Date), 0))<=$(=MonthEnd(Max(Date), 0))'}  >} PROJECTEDSALES)

Make sure your Date format is same

or Try this

Sum( {<Year={'=$(=Max(Year)),Month={'=$(Max(Month))} >} PROJECTEDSALES)