First() will give 0 for the first column
So you can extend your calculation to include that. Something like
if first()=0 then 0
iif(Sum([Number of Records])>=1,
I haven't tested it on your data. But checked on one of my reports
Thanks for the reply.
It still puts 0 in all null columns instead of the first and last.
IF (Sum([Number of Records])>=1)
first()=NULL OR last()=NULL THEN 0
Can you attach your workbook please or a sample excel data source
Also, your calculation is not using First() and Last() correctly.
They identify the first and last columns in the window. you cannot directly check if the value is null.
They can be used to select the column/row to use based on the offset you use.
First() itself is 0