• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

Simple Crystal Report's Question

How can I get the following formula to work in CR 7.0

if {audit_detail.accum} = "Y" then
  "Average: " +
  ToText(Sum(ToNumber({answer_detl.answer}), GroupName ({answer_detl.seq_no})))

This is giving me an error saying that a field is required where is says ToNumber, but the field answer_detl.answer is stored as text even though it is actually numeric.
0
Jagar
Asked:
Jagar
1 Solution
 
sujmagsCommented:
I created a table that matches ur case and tried to solve the problem,here u go

Create a formula field to compute ToNumber{answer_detl.answer}
say Formula1

now in formula2 , say sum(@formula1,groupcondition)

Now it never gives this error - "Field is required"

Hope this helps
0
 
JagarAuthor Commented:
Thank You it is amazing what you sometimes miss or don't think of.  I have this vastlt complex report working great, but here I forget how to do something simple.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now