Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=If(GetFieldSelections(FMonth)<>month(today()) Or and GetFieldSelections (YEAR) < Year(Today()),'NOT APPLICABLE',YOUR_RUN_RATE_EXPR)
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')