Error using Subset

Highlighted
Frequent Contributor

Error using Subset

Hi Anaplaner,

 

I wanna ask something

 

I have 1 module with 2 line item, line item 1 using list country and line item 2 using subset country,

i used formula in line item 2 reference to line item 1, but when when i selected in line item 1 ex China, why in line item 2 show China too, but in subset china is not availabe,

 

is that bug ?, or what ?

 

clipboard_image_1.png 

clipboard_image_3.png

 

Thanks and regard

 

Panji

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Error using Subset

Hi,

It appears to be a bug. Please go through the attached link, we have discussed the same topic in this post.

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Formulas-Not-Adhering-to-Subset-Format...

 

Try this workaround solution, 

1. If you have code in your Country List

FINDITEM('Country Subset' , CODE('1'))

 

2. If you don't have code in your Country List

FINDITEM('Country Subset' , NAME('1'))

 

 

Regards,

Vignesh M

Highlighted
Master Anaplanner/Community Boss

Re: Error using Subset

Please use finditem('SUBSET', CODE(ITEM(COUNTRY LIST))). This should work!!
Regards,
Kavin.