How to define firm category in a formula? 1

[dongw]

Hello, everyone,

In the system, except for all the firm information, we have 2 seperate tables showing "High Risk Firms" and "Priority Firms" which are targeted firms. Both "High Risk Firms"and "Priority Firms" are included in the system already. Now I am trying to do an analysis comparing the activities between "Targeted Firms" and "Non-Targeted Firms". I created a formula to define the firm category as follows:

if {Organization.ORGID}={HRSK.Orgid}
then "High Risk"
else if {Organization.ORGID}={Priority.Orgid}
then "Priority"
else "Non-Targeted"

But it doesn't work. I don't know what's wrong.

Thanks a lot for your help.

Dong

 

[lbass]

First, you should have a left join FROM {Organization.OrgID} to {HRSK.ORGID} and FROM {Organization.OrgID} to {Priority.Orgid}. Then change the formula to:

if isnull({HRSK.Orgid}) and
isnull({Priority.Orgid}) then "Non-Targeted" else
if isnull({HRSK.Orgid}) then "Priority" else
if isnull({Priority.Orgid}) then "High Risk"

-LB

 

[dongw]

Hi, Lbass,

Thank you a lot for your quick reply.

It works.


Dong