Using Record Number in formula

I have a report that uses the CR special field of "Record Number."  Also, the report has a formula field that generates a number, call it "Special Number."  I want to come up with the Sum({"Record Number} - {Special Number}).  How can I use the Crystal Reports "Record Number" field in a formula? The field does not come up in the Formula Workshop.
rbnazAsked:
Who is Participating?
 
frodomanConnect With a Mentor Commented:
It won't work directly with a sum, but you can write a formula to accumulate the values:

shared numberVar MyTotal;
MyTotal := MyTotal + (RecordNumber - {@SpecialNumber});

Then where you want to see the total just create a formula to show the variable results:

shared numberVar MyTotal;


0
 
rbnazAuthor Commented:
I get an error message of "This filed name is not known" for {RecordNumber}.
0
 
rbnazAuthor Commented:
I realzed my error and your formula worked!  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.