YTD revenue in crystals report

[ghmd47]

Hello,

my table have these data field Account, posting_date, fiscal_year and Tran_amount. I would like to create a calculation for revenue base on these field, but I can't get the YTD amount for Revenue. Here is my formula:
if({GLTran.Account} >=40010 and {GLTran.Account}<=44610) then {GLTran.Tran_Amount}
Base on this formula I can't get the YTD revenue amount. Please show me how to get the YTD revenue amount. Thanks

 

[IanWaterman]

Please do not double post.

Ian