Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
this is my expression
=SUM({<CUSTCLASSIFICATIONID={IAE,IAR,IAT,IAU,IBE,ICH,ICL,ICZ,IDK,IES,IFI,IFR,IHK,IIL,IIS,IIT,IKR,ILU,IMX,IMY,INL,IOM,IPL,IPO,IRC,ITW,IUK,IUS}>}
{<INVOICEYear={'$(vMaxYearInvoice)'},INVOICEDATE={'<=$(vMaxDateInvoice)'},INVOICEMonth=,INVOICEDay=,INVOICEMonthYear=>} SALESBALANCEMST)
the result is not right i didnt get the restricted value i get the whole sum, how can i combine the Set Analysis expressions?
thanx
Try this:
=SUM({<CUSTCLASSIFICATIONID={'IAE','IAR','IAT','IAU','IBE','ICH','ICL','ICZ','IDK','IES','IFI','IFR','IHK','IIL','IIS','IIT','IKR','ILU','IMX','IMY','INL','IOM','IPL','IPO','IRC','ITW','IUK','IUS'}
,INVOICEYear={'$(vMaxYearInvoice)'},INVOICEDATE={"<=$(vMaxDateInvoice)"},INVOICEMonth=,INVOICEDay=,INVOICEMonthYear=>} SALESBALANCEMST)
Try this:
=SUM({<CUSTCLASSIFICATIONID={'IAE','IAR','IAT','IAU','IBE','ICH','ICL','ICZ','IDK','IES','IFI','IFR','IHK','IIL','IIS','IIT','IKR','ILU','IMX','IMY','INL','IOM','IPL','IPO','IRC','ITW','IUK','IUS'}
,INVOICEYear={'$(vMaxYearInvoice)'},INVOICEDATE={"<=$(vMaxDateInvoice)"},INVOICEMonth=,INVOICEDay=,INVOICEMonthYear=>} SALESBALANCEMST)