Hello,
I currently have a field that has an expression that display a '0' in cases when the invoice due date has not passed and displays the invoice amount when the due date has passed.
Example:
=IIF(DateDiff("d",Fields!InvoiceDueDate.Value, Now()) >= "0", 0, Fields!Balance.Value)
I would like to get a total of this on the bottom but Sum(Fields!Balance.Value) will not work as it looks at the actual data and not the data being displayed after the expression. Any help in how I would go about getting the total for what is actually being displayed after the expression would be greatly appreciated.
Thanks in advanced,
Kei
I currently have a field that has an expression that display a '0' in cases when the invoice due date has not passed and displays the invoice amount when the due date has passed.
Example:
=IIF(DateDiff("d",Fields!InvoiceDueDate.Value, Now()) >= "0", 0, Fields!Balance.Value)
I would like to get a total of this on the bottom but Sum(Fields!Balance.Value) will not work as it looks at the actual data and not the data being displayed after the expression. Any help in how I would go about getting the total for what is actually being displayed after the expression would be greatly appreciated.
Thanks in advanced,
Kei