Logic required RUN RATE

[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

[anbu1984]

=If(GetFieldSelections(FMonth)<>month(today()) Or and GetFieldSelections (YEAR) < Year(Today()),'NOT APPLICABLE',YOUR_RUN_RATE_EXPR)

[#3]

Abhay, You can try like this:

if((GetFieldSelections(FMonth)=month(today()) and GetFieldSelections(YEAR) ='14-15'),

NUM((sum([Prd. Value]) / vCrore /count(Days)),0.00),'Not Applicable')