Calculated field and Picklist

Today Pankaj Juneja a reader of unleashed is sharing a case study where a Picklist on a calculated field helped him solve a problem.


Many of us know that a calculated field can be made editable by putting a pick list and a pick map to it. I always use to think that what’s the use of Calculated Field by making it editable by showing a pick list when a user really can’t do anything much with it.

Recently I came across a problem in which I used it to save myself from a tricky situation. I was using S_ORG_EXT_ XM table to build a new entity which is having 1: M relationship with Account. We used most of the ATTRIB columns rather extending table. There was one field where we used LOVs to display Data to user. As per client coding standards, we were supposed to store LIC value in tables and show display values since the Application was supposed to go Multilingual in coming years. Since I was not aware of this standard and I placed an LOV on field based on ATTRIB and stored display value in column.

I was using the below config , which is straightforward :

clip_image002

Picklist config –

clip_image004

When we realized this problem, I was suggested to make it Multilingual by giving Translation Table Name at column level but I realized that since it’s a reusable table (S_ORG_EXT_XM). Tomorrow someone else can use it for some other entity and if I give Translation table, then that column will be useless for that developer since it won’t accept values other than those LOVs. More over its OOB table so doesn’t wanted to touch it as it might hamper Application upgrade.

I just quickly analyzed that now calculated field can be used here. Here is how it worked for me.

Remove pick list from existing field, place it on calculated field.

clip_image006

A Calculated Field Looking up LIC and having Pick list with 2 Pick Maps.

Now expose the above Calculated Field in Applet rather Actual Field. This will always show Display Value to User and behind the scenes store LIC in table via Pick map. Even Query, Sorting worked fine.

7 Responses to Calculated field and Picklist

  1. I just want to know how this would be different from using LookupName() on the same field instead of creating a calculated

  2. Calculated field gives you better flexibility here…Added advantage is length restriction AS LIC is only 30 characters long. You can use Description in PickMap which enables you to sore values more than 30 characters.

  3. But description logic specified below will not work. Even we dont have logical function to get description like look up values. Please give me updates on my earlier comments.

    • Vishnu.. This post was created by me. Neel just posted it . I will reply to all your questions. Yes I did realize that I made a mistake in writing. By Siebel Rule ,Calculated Field is Never sortable.

      I tried Lookup in all languages. Picklist works fine in each application showing proper transalation. Please check if your configuration is correct.

      Lastly , I am not sure which Description Logic meant by Rahul.

Leave a Reply

Contribute