How do I do this

[satinsilhouette]

I have a field that if it is null then I need to look at antoher field and get the result here, BUT - I have a parameter that needs to feed off of this exchange.

Table A = Contract
Table B = Activity
Table C = Business Units

If isnull(contract.account_unit) then (Activity.Account_unit) else contract.account_unit

{?business_unit) = view.business unit - based off of contract.account_unit

Does the question make sense?

Thanks so much!
satinsilhouette

 

[satinsilhouette]

To add, I wonder if I can do it in the select criteria?

Record Selection

If isnull(contract.account_unit) then (Activity.Account_unit) else contract.account_unit

Thanks so much!
satinsilhouette

 

[lbass]

Can't see how business unit fits in. Are you asking whether you can set the formula to the parameter? The answer is yes:

{@yourformula} = {?unit}

-LB

 

[satinsilhouette]

LB Thanks for you repsonse -

Backdrop - there is a view that supplies the Business Unit based on the Account Unit. In the report the Business Unit is the parameter, but if the account unit is null or blank, than the Business Unit is as well. So I am trying to get the alternate account unit from the second table to be used in its place...

make sense?

Thanks so much!
satinsilhouette

 

[lbass]

Sorry, no, can't follow this.

-LB

 

[satinsilhouette]

To add if Account Unit = 77100 then Business Unit = US Revenue. But that exchange is done in the view. And in the view, no account units are null or blank. Only in the report.

Thanks so much!
satinsilhouette