SUM results in 0

[nesonica]

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

[felipedl]

Quicly seeing the set analysis, the Route field is set to "yes" and its a numerical fields, that by itself won't work.

Would need to see the value of vMinPeriodYear2 and vMaxPeriod2 to identify if it's getting any value;

[nesonica]

Thank you I just corrected the formula in my question, still no results unfortunately.

[felipedl]

Can you share both variables or the app as a whole?