Hi All,

I am trying to use aggregate formula with multiple conditions but it is throwing me an error.

Formula : sum_if((is_previous_nmonth("Current Year Primary"."Current_Month_SRD.Date",1))AND("Current Year Primary"."Current_Month_SRD.Date"<=previous_nmonth( current_date( ),1)),"Current Year Primary"."Current_Month_SRD.Qty",0)

Error: Parsing of given formula failed. Please check the syntax of the formula. Some tips: Parse error at line 1, column 79. Encountered: AND. Kindly enclose the column name(s) with double quotes. If it is just a string literal(or constant) value enclose it with single quotes eg.,'John Abraham'.