cannot do math on summed field?
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19756
Printed Date: 04 May 2024 at 4:20pm
Topic: cannot do math on summed field?
Posted By: celticpiping
Subject: cannot do math on summed field?
Date Posted: 11 Jul 2013 at 5:32am
|
this is killing me: goal: to perform math on a summary field(in a Group footer) problem: I cannot make crystal do math on a field that's "not recurring" see pic:  |
Replies:
Posted By: DBlank
Date Posted: 11 Jul 2013 at 7:45am
|
@invoice amount must be using @chargeback amount
what are these formulas?
|
Posted By: celticpiping
Date Posted: 11 Jul 2013 at 9:11am
|
"invoice amount' is simply multiplying two Darabase fields, as in: {InvoiceLines.Quantity} * {InvoiceLines.UnitPrice} so we have in the group footer, "sum of @invoiceamount(number)" field I was hoping I could simply use that summary field, in my chargeback amount formula ;( Rich |
Posted By: DBlank
Date Posted: 11 Jul 2013 at 10:24am
|
you cant really do conditional summary the wa you have it
if datediff('m',startdate,caceldate) in 3 to 7...
you can instead apply the condition to the formula and sum that formula
if datediff('m',{servicessetup.startdate},{{servicessetup.caceldate}) in 3 to 7 then (({InvoiceLines.Quantity} * {InvoiceLines.UnitPrice}) *(.75)) else 0
now sum this at the client footer
|
Posted By: celticpiping
Date Posted: 12 Jul 2013 at 9:54am
|
well done sir. thanks! R |