Format field based on number of rows - Report Designer 1.0

Question

I have a table in Report Designer 1.0. In the 'File' column there are multiple entries with the same file name. For each of these entries in the 'Total From File Header' column I'd like to replace the amounts with "N/A", except for the last entry. For example:

Currently:

    File1     $655.12
    File1     $655.12
    File1     $655.12
    File1     $655.12
    File1     $655.12
    File2     $59.33
    File2     $59.33
    File3     $124.12 
    File3     $124.12
    File3     $124.12
    File3     $124.12
    File3     $124.12
    File4     $12.33
    File5     $44.64

What I'd like to have:

    File1     N/A
    File1     N/A
    File1     N/A
    File1     N/A
    File1     $655.12
    File2     N/A
    File2     $59.33
    File3     N/A 
    File3     N/A
    File3     N/A
    File3     N/A
    File3     $124.12
    File4     $12.33
    File5     $44.64

I tried the following, which didn't work. Any tips?

=IIF(Count(Fields!AMA_FILENAMEKEY.Value)<CountRows(Fields!AMA_FILENAMEKEY.Value),"N/A",Val(Fields!TOTALPOINTSOFFILE.Value))

Answer 1

Try something like this.

=IIF(RowNumber("DataSetGroup")<CountRows("DataSetGroup"),"N/A",Fields!TOTALPOINTSOFFILE.Value)

I would prefer solving this in dataset (or sql) instead of formatting(or fixing) it in the report designer.