Relax, figuring out how to 'see' what Crystal is doing and correct is what makes us valuable.
In the formula that I wrote, it will only display the results of formula1, which is probably not what you want/expect.
Create another formula that just displays the values, they are really simple and would look like:
shared numbervar formula1
and the other would be:
shared numbervar formula2
place these on the report, and see if they display the values that you expect. If you really want to see if the formulas are working, move them to the detail section and watch as they increment...perhaps one of them is wrong and is not doing what you want, but then you will be able to see the pattern(hopefully) and correct it.
as a note, if you want to hide the values in the first formula that I responded with, add a line and just have a empty string in it (""). Crystal displays the last printable item in a formula, regardless of what it is, so "" just prints that and 'hides' the results of the formula, which would/could appear to be complete gibberish as far as the user is concerned.
Hope this helps...really, relax, we all have been frustrated and confused and at times completely pissed off at Crystal.
IP Logged
