Hello Everyone,

This was the another requirement which I had in the same report which I designed and explained in my Previous blog. Here I was required to count the total no of rows in the columns which contains the data.

I used the function ‘SUM’ under Aggregate in the Expression to count.

Then I completed the Expression with checking the Field value using IIF condition, and summing up only the fields containing data.

I was then able to calculate the sum of rows under columns containing values.

Hope this will be Helpful.

Thanks !!!