2)splitting it into two formula fields: Make one formula called "Price" with the following code: ToText({Table.Price}) Then create a new formula to create your sum, Sum({@Price})
still iam not getting output it shows error like"A number field or curreny field required".
rkreddy2010....
Member
5 Points
28 Posts
How to find the sum of string Field values in crystal report
Jul 28, 2012 09:00 AM|LINK
my column value table.price is a string
iam trying like
1)Sum(ToNumber({Table.Price}))
2)splitting it into two formula fields:
Make one formula called "Price" with the following code:
ToText({Table.Price})
Then create a new formula to create your sum,
Sum({@Price})
still iam not getting output it shows error like"A number field or curreny field required".
how to solve this problem in string sums