Simple Question on a Descriptor Field.

Question

Please see the below table:

The first column is the account, the second column is the sub-account, the third column is the description for the combined account with the sub-account.

I need to change the information in the fourth column to show the description located in the '00' sub account for each account For example, in the column labeled "'00' Description", I need to show all sub-accounts of 900654 with  the description 'Space Rental'.

I need to show all sub-accounts of 900760 with  the description 'Administrative Overhead', etc. .

Thanks in advance for your help.

Bob

1008490 · Answer

yes Thomos, I gree this is one time solution. I given to solve current requirement.

Thomas Dodds · Answer

That's the one-time solution ... USE of information drives design.  Spend the effort and do it right; then it will perform better and is much more usable.

1008490 · Answer

Hi,

You want to show if the the Account no is  900654 then 'Space Rental' use case statement.

edit formula write like below:

Ex Case when accountnumber=900654 then 'Space Rental'

casw when accountnumber=900760 then 'Administrative Overhead' else accountnumber end