CODEWITHSUNDEEP
crystal-reports
JetJack
JetJack

Reputation: 988

How to sum of the specified column value

Using Crystal Report 7

ID Value

001 100
002 200
003 400
004 500
...

I have n number of row, from that i want to sum of value from 003 to n, i don't want to sum of 001 and 002.

In a report footer, i need to add sum of value from 003 to n.

How to create a formula for the above condition, Need formula help

Upvotes: 0

Views: 1837

Answers (1)

Lee Tickett
Lee Tickett

Reputation: 6027

You can use the same solution as: How to add rows at runtime

  • Create a new formula field: if {table.id} in ['001', '002'] then 1 else 2;
  • Create a group using this formula
  • Suppress the group header
  • Add your total fields to the group footer (you will get a total of 001 + 002 then a total of 003... n

Upvotes: 1

Related Questions