Skip to Content
Former Member
Nov 18, 2016 at 02:21 PM

Trying to create a total line based on Subtotal of Distinct Values


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.