Hello,
Using: CR XI, Oracle DB
My issue is that within the Group it is counting the multiple records. I need the formula to only count permit once.
here how the data looks now
Add# Type Permit Open
3336 (Group1) House number
12345 (Group2) permit number
S-CAP CERT - 9Group3) agency
"" or Hold (Group4) decision code
3336 BLR1 12345 YES 1
3336 BLR1 12345 YES 2
this is how it should look:
3336 (Group1) House number
12345 (Group2) permit number
S-CAP CERT - (Group3) agency
"" or Hold (Group4) decision code
3336 BRL1 12345 YES 1
3336 BRL1 12345 YES 1
Need to unique count records that meet a criteria.
Expected Output
Placed in the GF1
Department
arborist 12
Zoning 2
S-Cap 1
I am using the standard Manual Running total formulas
//@Agency place on detail line.
WhilePrintingRecords;
Numbervar ScapCountPlans;
If (GroupName ({MAJOR_PROJECT_VIEW.ACT_CODE})="S-CAP CERT" and {@OpenApplications}='YES')
then
ScapCountPlans := ScapCountPlans + 1
else
ScapCountPlans:= ScapCountPlans
@agency is referring to another formula named @OpenApplications
//@OpenApplications
If GroupName ({MAJOR_PROJECT_VIEW.ACT_CODE}) in ['HOLD'] or isnull({MAJOR_PROJECT_VIEW.PER_ACT_DECISION})
//iF (({PER_ACTIVITY.PER_ACT_DECISION} = 'HOLD') or (isnull({PER_ACTIVITY.PER_ACT_DECISION}))
then
// HOLD - OPEN
'YES'
Else
// Approved
'NO'
Thanks
Greg
Using: CR XI, Oracle DB
My issue is that within the Group it is counting the multiple records. I need the formula to only count permit once.
here how the data looks now
Add# Type Permit Open
3336 (Group1) House number
12345 (Group2) permit number
S-CAP CERT - 9Group3) agency
"" or Hold (Group4) decision code
3336 BLR1 12345 YES 1
3336 BLR1 12345 YES 2
this is how it should look:
3336 (Group1) House number
12345 (Group2) permit number
S-CAP CERT - (Group3) agency
"" or Hold (Group4) decision code
3336 BRL1 12345 YES 1
3336 BRL1 12345 YES 1
Need to unique count records that meet a criteria.
Expected Output
Placed in the GF1
Department
arborist 12
Zoning 2
S-Cap 1
I am using the standard Manual Running total formulas
//@Agency place on detail line.
WhilePrintingRecords;
Numbervar ScapCountPlans;
If (GroupName ({MAJOR_PROJECT_VIEW.ACT_CODE})="S-CAP CERT" and {@OpenApplications}='YES')
then
ScapCountPlans := ScapCountPlans + 1
else
ScapCountPlans:= ScapCountPlans
@agency is referring to another formula named @OpenApplications
//@OpenApplications
If GroupName ({MAJOR_PROJECT_VIEW.ACT_CODE}) in ['HOLD'] or isnull({MAJOR_PROJECT_VIEW.PER_ACT_DECISION})
//iF (({PER_ACTIVITY.PER_ACT_DECISION} = 'HOLD') or (isnull({PER_ACTIVITY.PER_ACT_DECISION}))
then
// HOLD - OPEN
'YES'
Else
// Approved
'NO'
Thanks
Greg