Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

formula

Posted on 2011-02-23
2
Medium Priority
?
298 Views
Last Modified: 2012-05-11
Hi Guys,


I need a formula so I can finalise my report. I'm trying to get 10% of the value of this {@sum_condition_value}

my formula

if Val( {@sum_condition_value} ) > 0 then {@sum_condition_value} *.1
   
else 0
   
But, it produces an error.
a-number-or-currency-amount-is-r.bmp
0
Comment
Question by:mcse2007
2 Comments
 
LVL 12

Accepted Solution

by:
JayConverse earned 1000 total points
ID: 34966344
@sum_condition_value isn't a number.  Use Val({@sum_condition_value})
0
 
LVL 7

Author Closing Comment

by:mcse2007
ID: 34966401
thanks for your help
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question