Sometimes you need to bring duplicated data from your Data Source using union in order to bring all requested information.
Last post I`ve showed you how to remove duplicated detail line from the report.
Today I`ll show you what to do when you need to sum the actual lines.
If you`ll create a new running total fields formula you`ll get all the lines including null for the duplicated lines.
If you want only to count the not null rows select "Use a formula" and click the formula button.
And then enter the formula as below:
not isnull({TableFieldName})
Now the total will bring you only the not null row.
Good luck
Shahar
No comments:
Post a Comment