troubleshooting Question

A number of currency amount is required here.

Avatar of mcse2007
mcse2007Flag for Australia asked on
Crystal Reports
7 Comments2 Solutions2540 ViewsLast Modified:

I'm trying to calculate 10% of my site delivery charge which is tax component but CR is having difficulty via the formula producing the result.

if {Sheet1_.ZFR2 - Site Delivery} <=0 then "0"
else ({@sdelivery-unit-cost} *.10)

when I check the formula, it highlight this   (@sdelivery-unit-cost}  as part of the error in the formula

@sdelivery-unit-cost is....
if ({Sheet1_.ZFR2 - Site Delivery}) <=0 then ""
else {@sdelivery-sum}

@sdelivery-sum is....
CStr(sum ({Sheet1_.ZFR2 - Site Delivery}, {Sheet1_.Bill#Doc#}),2,'')

Any idea how to fix this?

appreciate your help.
Kurt Reinhardt
Sr. Business Intelligence Consultant/Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros