Hi All,

I have a simple report with a row grouping on teh Date and record_id from an sql query. I would like to find the row total.

The expression I have on the row is:

=IIF(Max(Fields!closing.Value) > 0, Microsoft.VisualBasic.Interaction.IIF(Max(Fields!opening.Value) > 0, IIF(Max(Fields!closing.Value) > Max(Fields!opening.Value), Max(Fields!closing.Value) - Max(Fields!opening.Value), Nothing), Nothing), Nothing)

Please assist,

Many thanks

Regards

Zimiso

Hi Zimiso,

According to your description, you want to compare the closing and opening fields and get row total, right?

In your scenario, you can simplify your row expression, please refer to the following expression:

=IIf(Max(Fields!closing.Value) > 0 and Max(Fields!opening.Value) > 0 and Max(Fields!closing.Value) > Max(Fields!opening.Value), Max(Fields!closing.Value) - Max(Fields!opening.Value) , Nothing)

If you have other issue, please share error code or error images.

Regards,
Shrek Li