I am new to CR but what I am trying to do seems simple.  I want to identify a text field and then back up one record to capture the previous text field.  After applying the formula below I receive the error "A number, currency amount, time or date-time is required here".

 

 

 

 

Now that I can get the previous field another issue occurs in the report.  Because of the formula I am using there is a lot of unnecessary filler data making the report about 35 pages when I only need about 2 pages.  So I sort by another field (time) to nicely group the data I am after but that breaks my "previous" formula because another field entry is the new "previous".  If there was someway to "freeze" the report before sorting would be nice.  Or I'm sure there is a neat trick to blow away the filler data but I haven't figured that out yet.

 

Thanks

 

Chris

 

The problem with the report is the quantity column is returning the value 0 if the condition below is not met (I am trying to eliminate the negative numbers).

 

thanks.