Hi there.
i have the following Formular
if ({S501.SPTAG} in
date(year(currentdate)-1,month(currentdate)+1, 1) to currentdate)
then ({S501.UMKZWI3}-{S501.GUKZWI3})
else 0;
Formular works perfect, except for the last Month (31.December) it didnt work. December should have been the total from Jan,1 2012 to Dec,31 2012. But the formular brought Jan 2011 back. How can i work around it so when the currentdate is december, that it would just take the total from Jan-Dez and all the other months my formular ?
Can anyone help ?
Jacky
IP Logged
