Identifying if a list item is a property on a separate list

Hi,

I have two numbered lists, City and Product.

Product has City as a property.

All Products have a City as a property, and multiple Products can have the same City as a property, but not all Cities may be linked with a Product.

In a module with City list as a dimension, how could I identify if a City has been linked with a Product (it doesn't matter if it's one or many)?

Thanks,

Accepted answers

kavinkumar

HI Ceri,

You can bring it in this way. Please follow the steps below.

Step 1: In your Product list add a number formatted line item and make it as 1 in the forumula

Identifying if a list item is a property on a separate list.PNG

Step 2 : In your module just do refer the above property(Count) by putting SUM:Country list property and you will get the count as no.of products and if it is 0 then that City is not linked to any Products. In my example "Chennai" city is not linked to any of the products.

Identifying if a list item is a property on a separate list 1.PNG

Hope this confirms your requirement. Let me know if you have any concerns.

Thanks,

Kavin.

All comments

kavinkumar

HI Ceri,

You can bring it in this way. Please follow the steps below.

Step 1: In your Product list add a number formatted line item and make it as 1 in the forumula

Identifying if a list item is a property on a separate list.PNG

Identifying if a list item is a property on a separate list 1.PNG

Hope this confirms your requirement. Let me know if you have any concerns.

Thanks,

Kavin.

rob_marshall

The above will work, but please don't put those line items in a list, put them in a Module as this will help performance, will help with the general understanding and maintaining of the model, as well as show up on the Model Map (list properties do not show up on the model map).

Thanks,

Rob

Quick Links

Can you help?

Unanswered questions

Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…