CODEWITHSUNDEEP
crystal-reports
Ishanka25
Ishanka25

Reputation: 93

Sum of a column ignoring " - " mark

I want to generate a report that looks like this:

enter image description here

I used the following formula to get the age analysis totals.

if {Table.drange} = "1-30" then
    totext({Table.balance})
else
    totext("-")

Since I converted the number into a string with the formula, I can't get the sum at the bottom of the report. How can i display "-" instead of zero values, but still get a total value?

Upvotes: 0

Views: 44

Answers (1)

CoSpringsGuy
CoSpringsGuy

Reputation: 1645

Change your formula back to this:

if {Table.drange}="1-30" then
  {Table.balance}
else
  0

Then right click the formula and select Format Field. Under the number tab, select Customize. You can then total this column as you desire

Upvotes: 1

Related Questions