Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This set function is supposed to sum price*Qty for current Financial Week's (FWeek). FWeek is a field in a list Box That can filter more than one week. the set Calc works when filtered to current week but not more than 1 Week.
How does it need to change to sum up ALL selected Weeks ?
sum({1<FWeek = {$(=FWeek)} } >} (PLU_PRICE*QUANTITY))
ColinR
Duplicate Post, Appologies to All please ignore
(Post timed Out so re-posted)
Duplicate Post, Appologies to All please ignore
(Post timed Out so re-posted)