Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
unfortunately I do not get any results in the Bonus-free Route with the formula:
Sum({<PeriodMath={'>=$(vMinPeriodYear2)<=$(vMaxPeriod2)'},Route_FLAG={'yes'},[Margin after Bonus]=[Margin]>}Sales)
Could you please help me out with this one? Thanks in advance!
MATKL | Sales | Route | Bonus | Bonus% | Bonus-free Route | Margin | Margin after Bonus |
899001 | 3.380 | 3.380 | 0 | 0 | 0 | -733,28 | -733,28 |
519005 | 2.465 | 2.465 | 0 | 0 | 0 | 415,12 | 415,12 |
519005 | 2.083 | 2.083 | 0 | 0 | 0 | 351,04 | 351,04 |
899001 | 1.945 | 1.945 | 0 | 0 | 0 | 19,84 | 19,84 |
899001 | 1.862 | 1.862 | 0 | 0 | 0 | 85,31 | 85,31 |
519005 | 1.819 | 1.819 | 0 | 0 | 0 | 306,99 | 306,99 |
519005 | 1.588 | 1.588 | 0 | 0 | 0 | 267,49 | 267,49 |
519005 | 1.566 | 1.566 | 0 | 0 | 0 | 263,7 | 263,7 |