This is for Naith
I am to have a report from 1st of April to the end of the
previous month i.e. upto March next year.
//Current Year's April to End of Last Month
If minimum({PPFTXN.VOUCHDT}) >= date(year({PPFTXN.VOUCHDT}),04,1) and
maximum({PPFTXN.VOUCHDT}) <= date(year({PPFTXN.VOUCHDT}),04,30) then 0
else
if month({PPFTXN.VOUCHDT}-1) in [6,9,11]
then
if {PPFTXN.VOUCHDT} >= date(year({PPFTXN.VOUCHDT}),04,01) and
{PPFTXN.VOUCHDT} <= date (year({PPFTXN.VOUCHDT}),month({PPFTXN.VOUCHDT}-1),30)
then
{@debits}
else
( if (month({PPFTXN.VOUCHDT}-1) in [1,3,5,7,8,10,12])
then
if ({PPFTXN.VOUCHDT}) >= (date(year({PPFTXN.VOUCHDT}),4,1)) and
({PPFTXN.VOUCHDT}) <= (date (year({PPFTXN.VOUCHDT}),month({PPFTXN.VOUCHDT}-1),31))
then
({@DEBITS}))
else
if month({PPFTXN.VOUCHDT})-1 in [2]
then
if {PPFTXN.VOUCHDT} >= date(year({PPFTXN.VOUCHDT}),4,1) and
{PPFTXN.VOUCHDT} <= date (year({PPFTXN.VOUCHDT}),month({PPFTXN.VOUCHDT}-1),28)
then
{@debits}
The above formula was used as suggested by you. the following problems are faced by me:
1.I am unable to have a subtotal after inserting the first
three lines I.e. min of vouchdt and max of vouchdt.
2. The formula works only for 6,8,10 where no of days
are thirty and for the reminaing 5,7,9 it does give me 0.
3. Am I correct in using the above formula for months 1,2,3.
Can you help me sir. I am suppose to deliver the project mid June and I am stuck with this report.