Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have the following table.
The backorder expression is:
If(Match(OrderStatus,'900540','914999','904550','914550','904540'),if(vExcludeInstrumentSales,sum({<Year=,Month=,Quarter=,Day=,Invoice_Date_Num=,Invoice_Date=,Item_Category={$(vNoInstruments)}>}DistPOExtendedUSD),Sum({<Year=,Month=,Quarter=,Day=,Invoice_Date_Num=,Invoice_Date=,Item_Category={$(vNoInstruments)}>}DistPOExtendedUSD)),0)
and this formula is working ONLY if on the table the dimension OrderStatus is available - if i remove the dimension order-status, doesn't work. Anyone knows how i can fix this?
Thank you!
May be try this
Sum({<Year, Month, Quarter, Day, Invoice_Date_Num, Invoice_Date, Item_Category = {$(vNoInstruments)}>} Aggr(
If(Match(OrderStatus,'900540','914999','904550','914550','904540'), If(vExcludeInstrumentSales, Sum({<Year, Month, Quarter, Day, Invoice_Date_Num, Invoice_Date, Item_Category = {$(vNoInstruments)}>} DistPOExtendedUSD), Sum({<Year, Month, Quarter, Day, Invoice_Date_Num, Invoice_Date, Item_Category = {$(vNoInstruments)}>} DistPOExtendedUSD)), 0)
, OrderStatus))