Hello,
I have a formula that is flagging either YES or NO. Here it is below:
@CheckPending
If (GroupName ({PENDING_VIEW.PER_ACT_DECISION}) in ['APPR', 'APPR W/C','APPR W/P','APPROVED'])
then
// Activity Approved
'YES'
Else
// Hold Open
'NO'
Im using this flag to help in calcalutions in other formulas
The report looks like this:
Group1 is the application number
Group2 is the agency
Group3 is decision code (Approved or Hold)
BL1-0001 - Group1
Agency1 - Group2
Approved - Group3
BL1-0001 Yes
BL1-0001 Yes
BL1-0001 Yes
Hold - Group3
BL1-0001 NO
BL1-0001 NO
Agency2 - Group2
Hold - Group3
BL1-0001 NO
BL1-0001 NO
The applications can go to many different agencies. On the Group2 level I only need to check if there is a HOLD on that application. In Agency1, the agency put it on HOLD then later APPROVED it, but I do not need to flag those NO. Only applications with Holds...
What's wrong with my logic for @CheckPending
Thanks,
I have a formula that is flagging either YES or NO. Here it is below:
@CheckPending
If (GroupName ({PENDING_VIEW.PER_ACT_DECISION}) in ['APPR', 'APPR W/C','APPR W/P','APPROVED'])
then
// Activity Approved
'YES'
Else
// Hold Open
'NO'
Im using this flag to help in calcalutions in other formulas
The report looks like this:
Group1 is the application number
Group2 is the agency
Group3 is decision code (Approved or Hold)
BL1-0001 - Group1
Agency1 - Group2
Approved - Group3
BL1-0001 Yes
BL1-0001 Yes
BL1-0001 Yes
Hold - Group3
BL1-0001 NO
BL1-0001 NO
Agency2 - Group2
Hold - Group3
BL1-0001 NO
BL1-0001 NO
The applications can go to many different agencies. On the Group2 level I only need to check if there is a HOLD on that application. In Agency1, the agency put it on HOLD then later APPROVED it, but I do not need to flag those NO. Only applications with Holds...
What's wrong with my logic for @CheckPending
Thanks,