Total variables in a footer based on report date - Acumatica Report Designer

RE: Total variables in a footer based on report date

Felipe Garcia — Thu, 30 May 2024 14:06:33 +0000

Tim, thank you for responding. What I am trying to display is the sum of =$PayAmount which is=Payments.CuryConvCury(, , , , )-$DiscTaken as of the day the customer chooses or less. I'm sure I can figure out the greater than part once I figure out the first total. I can get a total to display it's just not the correct total. For some reason anything I try only wants to show one line item only and doing a simple =SUM($PayAmount) starts to make the report go crazy. Not sure what other ideas I can try. So for example I have =Sum(IIf( >= @ReportDate, $PayAmount, 0)) $PayAmount just won't display how I want it.

3487 3488

RE: Total variables in a footer based on report date

Tim Rodman — Thu, 30 May 2024 13:37:14 +0000

You actually don't even need a report variable for this. I'm typing this on my phone and going off of memory here, but I think you'll get the general idea. You could do something like this:

=IIf(
DateDiff(,Today())<0 or
DateDiff(,'2024-06-08')<0,
,
0
)

Total variables in a footer based on report date

Felipe Garcia — Thu, 30 May 2024 11:05:08 +0000

Hello, I am wondering if anyone can help me, I am creating a customer Projected Payment Report based off Bills Pending Payment, and the report is good except for the totals I am looking for at the end. The $PayAmount variable is making this tricky for me. I simply want to sum everything less than the report date (Yellow) and greater than or equal to the report date of 06/08/2024 (Red).

3485 3486

Thank you