This content has been marked as final. Show 5 replies
|Customer Name||Month||Year||CummPerc Cube||Commission|
I need an expression where the user selects a Year and a Month and a percent (based on a Variable) and it returns the sum of all commission for that year and all months <= Month selected, IF the total commission IF "CummPerc Cube" is <= the variable selected.
So for example if the user selects Year: 2012, Month: 02 and the Variable of .82 the the returned object would be:
|Customer Name||CummPerc Cube||Commission|
because Customer A is the only one that had "CummPerc Cube" value of under .82 in the month/year that was selected.