Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to get AND OPERATION for below expression.
Right now it is performing OR operation of these 2 conditions where Won or Pipeline met but i need both Won and Pipeline to meet the condition
Can someone please help
Sum(
{<
Won=
{"<$(=(
Max(Aggr(Sum({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}Won),RecordID))
+
Min(Aggr(Sum({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}Won),RecordID)))
/2)"},FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=
,
Pipeline=
{"<$(=(
Max(aggr(Sum({<FiscalYear={'$(vMaxYear)'},Fiscal_Month_Number={'$(=Max({<FiscalYear = {'$(vMaxYear)'}>}Fiscal_Month_Number))'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}Pipeline),RecordID))
+
Min(aggr(Sum({<FiscalYear={'$(vMaxYear)'},Fiscal_Month_Number={'$(=Max({<FiscalYear = {'$(vMaxYear)'}>}Fiscal_Month_Number))'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}Pipeline),RecordID)))
/2)"},FiscalYear={'$(vMaxYear)'},Fiscal_Month_Number={'$(=Max({<FiscalYear = {'$(vMaxYear)'}>}Fiscal_Month_Number))'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=
>}
Pipeline)
Any one?
Any one?