Code formula

Hi All,

Just another simple one this time. I need to capture the code of the L0 Hospital subsidiary. I tried code(item('L0 Hospital Subsidairy')) formula in a text formatted line item i keep getting an error. i need to put the L0 code on the hospital code column to match the L3 department.

the hospital code column is text formatted. is that where I have an issue? should I change it to a list formatted line item?

Any ideas?

Regards,

Accepted answers

All comments

Venki9902

Hi @Jsdeloria21 ,

Can you please share the blueprint view if possible?

Regards,
Venkatesh

pyrypeura

Hi,

As your model is not dimensionalised by 'L0 Hospital Subsidiary' you can't reference those items with ITEM() in the module. You would need to use correct amount of PARENT functions to get L0 level for your L3 items to get item of list L0. From this item you can then get the code with CODE() function.

mikem

Juding by your screenshot it looks like the module is L3 and you need L0 code which leads me to believe you have two additional levels in between (L2 and L1). You can take do something like Code(Parent(Parent(Parent(Item(L3))))) but that's definitely not best practice. I would instead recommend setting up an attributes module for your L3 level then create separate Parent line items and calculate the code off those parent line items. You can calculate this information once in your attribute module and reference as much as needed.

elainecooper

@drift hunters Change the column formatting to "List" instead of "Text" in the data source editor. Then set the list of valid choices for hospital codes. This will make it a dropdown list column.

larryellison

@Jsdeloria21 geometry dash bloodbath Need to size and reference those items using ITEM() in the module. To get the item in list L0 it is necessary to use the correct number of PARENT functions.

unknown

This content has been removed.

Akhil Vemula

Hi @Jsdeloria21 For the formula to work you need to have Dimension of the list(L0 Hospital Subsidiary) in the "Applies To" of that line item.

AndyMurray

The game challenges players to navigate the complexities of a relationship with a possessive AI girlfriend. The primary objective in yandere aigirlfriend simulator is to prevent jealousy while maintaining affection.

hotessay

立即联系我们，了解更多关于我们网课代上服务的信息，让我们成为您在海外学业道路上的有力支持。通过我们的服务，您将能够更加轻松、自信地应对留学生活中的各种挑战，取得理想的学业成绩，享受更加丰富多彩的留学体验。

GaelBrown

If @Dress to impress 'L0 Hospital Subsidiary' is a list, your line item should be list-formatted rather than text-formatted. The formula CODE(ITEM('L0 Hospital Subsidiary')) should work if the list is correctly referenced. If you’re still getting an error, check whether the line item is linked properly to the list. Converting the column to a list format might resolve the issue.

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…