If condition

[#1]

The calculation below is not working,The if conditions are not getting satisfied. Please help

=IF(MATCH(FC.DATE_FISCAL_MONTH_NUM_LONG,3,6,9,12)>0 and Type='P',

SUM({<FC.DATE_FISCAL_YEAR_LONG={$(vCurrentYear)},FC.DATE_FISCAL_MONTH_NUM_LONG={">=$(vPrevMonth)<=$(vCurrentMonth)"}>}([Direct Hours]/200)),

SUM({<FC.DATE_FISCAL_YEAR_LONG={$(vCurrentYear)},FC.DATE_FISCAL_MONTH_NUM_LONG={">=$(vPrevMonth)<=$(vCurrentMonth)"}>}([Direct Hours]/160))

)

[#2]

Thanks Micheal,

I have not cleared the cache and was trying different calculations, Once I cleared the cache and re applied the calculation it has worked.

Thanks again

have a good day!