I have a report in Web Intelligence that in the subtotal line calculates the following:
=If IsString(If [Contract Status]="Active" Then "GREEN") Or IsError(If [Contract Status]="Active" Then "GREEN") Then 1 Else 0
This gives a value of 0 or 1. What I need in the total line is the sum/count of all these lines that are 1. My Report block has 26 lines of which 4 are 0 so my total should be 22. I am getting 1 when I try ForEach or In and with ForAll I am getting 79 which is completely wrong. Need this urgently to solve a reporting situation.