I have a report that has null values.(Postdate). I used the following formula to fill the Nulls (PostdateFill)

if isnull({TKPay.PostDate}) then previous({TKPay.PostDate}) else ({TKPay.PostDate})

The Problem I'm running into is multiple Null values in a row. A little help on this would be great. Thanks( I cant have any nulls in postdatefill as my report will use this column at a pay period post.)

Postdate   PostdateFill   
20140721   20140721
20140721   20140721
                 20140721
20140721   20140721
                 20140721
           
20140721   20140721

Edited by zunigap2302 - 22 Jul 2014 at 8:31am

I used the maximum and it worked however I ran into a problem. The group I used was for individual date. I need to figure a formula for holidays that have no postdate in the group... any suggestions?

Edited by zunigap2302 - 22 Jul 2014 at 11:54am