>Hi Cetin,
>
>I got the amount on the columns by using the expression
>iif(betw(nAveD,1,20),nAmount,0)
>
>Where nAveD is a variable set to average the Days per transaction group
>
>but getting the total of each column using the expression above with the sum gives a wrong answer. It adds the amount n times. Example below total for column 1 should be 4000 but using the expr above it comes out 8000 (1000+1000+3000+3000).
Hi Alvin,
Doing with report vars killing me either. I find it easier to do with SQL. Note that report fields have no alias just fieldname (which makes them free of source so you could do final SQL to a nonpredetermined cursor - report DE is empty).
select avg(days) as avg_days,transnum ;
from crsTransactions ;
group by transnum ;
into cursor crsAverage ;
nofilter
select a.transnum, a.days, a.amount, ;
iif(between(b.avg_days, 1,20),1,0)*a.amount as c1, ;
iif(between(b.avg_days,21,30),1,0)*a.amount as c2, ;
iif(between(b.avg_days,31,40),1,0)*a.amount as c3 ;
from crsTransactions a ;
inner join crsAverage b ;
on a.transnum = b.transnum ;
into cursor crsReport ;
nofilter
Cetin
