Hi All
I have a TY and LY expression that returns the correct value
TY: If((Avg({<[SK Ldow No]={"$(=Max([SK Ldow No]))"}>}([Binc Previous RSP]-[Binc Current RSP])))>0,
(Sum({<[SK Ldow No]={"$(=Max([SK Ldow No]))"}>}([Cls Stk Qty]+[In Trnst Qty]))),0) = 7 697 656
LY: If((Avg({<$(vClearDates), [SK Ldow No]={"$(=Max([SK Pyr Ldow No]))"}>}([Binc Previous RSP]-[Binc Current RSP])))>0,
(Sum({<$(vClearDates), [SK Ldow No]={"$(=Max([SK Pyr Ldow No]))"}>}([Cls Stk Qty]+[In Trnst Qty]))),0) = 7 123 552
When I apply the Aggr function only my TY returns the correct value, my LY is incorrect. What am i doing wrong in my LY Aggr expression?
TY: Sum(Aggr((If((Avg({<[SK Ldow No]={"$(=Max([SK Ldow No]))"}>}([Binc Previous RSP]-[Binc Current RSP])))>0,
(Sum({<[SK Ldow No]={"$(=Max([SK Ldow No]))"}>}([Cls Stk Qty]+[In Trnst Qty]))),0)), Subclass, Style, SKU)) = 7 697 656
LY: Sum(Aggr((If((Avg({<$(vClearDates), [SK Ldow No]={"$(=Max([SK Pyr Ldow No]))"}>}([Binc Previous RSP]-[Binc Current RSP])))>0,
(Sum({<$(vClearDates), [SK Ldow No]={"$(=Max([SK Pyr Ldow No]))"}>}([Cls Stk Qty]+[In Trnst Qty]))),0)), Subclass, Style, SKU)) = 6 209 187
