Select Most Recent Value from Non Recurring Field 1

[mwake]

I'm using CR13 with an Oracle db as my data source. I've got a quota attainment report and the SQL is currently only returning quota attainment % if there are sales in the period. The client wants an attainment % each month and if there are no sales in the current month, the % attainment should equal the most recent attainment %. If I have sales in January and February but not in March, how do I write a formula so that March displays the attainment % from February?? For this example, there would be a % for period 1 and period 2, but no record for period 3. Basically I need to use the period value if it exists, and the most recent period value if the period value does not exist.

 

[padytom]

can you try something like this? I haven't tried it though
if isnull({field}) then previous({field}) else {field}

 

[kenhamady]

There isn't a simple way to do this because CR only reports on data that exists. It can't automatically generate data that isn't there. There are some workarounds in an old newsletter I posted here:

http://www.kenhamady.com/newsletter/news0208.shtml

If we are talking about one or two missing periods you might find method 6 is best, especially since you want to use the same values as the period prior.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/