Skip to Content
0
May 09, 2016 at 05:43 PM

adding weekly totals

22 Views

Hello,

Looking for some assistance here once again 😊

I need to add totals for weekly totals here. They need to between week 10 and week 14.

Here is what I have, but it an error when I check it, it's highlighting from the else if statement to the end, saying the remaining text does not appear to be part of the formula:

Numbervar Total;

if isnull ({V_PART_REL_WEEK_DATA.WEEK_REL_QTY_FOR_EA_WEEK}) then

Total:= Total +0;

else if {V_PART_REL_WEEK_DATA.WEEK_CALC_DATE} IN DateAdd('ww',10,Minimum(WeekToDateFromSun))TO DateAdd('ww',14,Minimum(WeekToDateFromsun)) THEN

Total:= Total + {V_PART_REL_WEEK_DATA.WEEK_REL_QTY_FOR_EA_WEEK};

Any help will be appreciated.

Thank you,
Gerald