Determine if List Item has been used in List Formatted Line Item

Hi team,

I have a list of #Employees & am allocating a #Job Role to each of them (results in module EM23) & want to highlight which list items in the #Job Role list have not been allocated to a #Employee in module EM23

I tried using FINDITEM (see below in EM43) but this not returning anything due to it being dimensionalised by #Job Role.

Is there anyway of performing this check - feel like there is but I am on the wrong track!

Thanks!

Accepted answers

kavinkumar

HI @MarkTurkenburg,

Try creating a boolean formatted line item and make it as true in 'EM23'. Then try to bring this info to your EM43 thru 'ANY' function. Example below,

Hence by this way, you can find whether a role has been assigned or not .

Hope this helps!!

Regards,

Kavin.

All comments

kavinkumar

HI @MarkTurkenburg,

Try creating a boolean formatted line item and make it as true in 'EM23'. Then try to bring this info to your EM43 thru 'ANY' function. Example below,

Hence by this way, you can find whether a role has been assigned or not .

Hope this helps!!

Regards,

Kavin.

nathan_rudman

In your employee module, create a line item called "Role Counter" with a formula

IF ISNOTBLANK('Job Role #') then 1 else 0

Now created a new module with the Role as a dimension and one line item "Used Count". The formula of this line item should be:

'EM23 - Employee Details'.Role Counter[SUM:'Job Role #']

This modulw will now show you how many times a role has been used. You can sort/highlight/filter to show the 0.

kavinkumar

@nathan_rudman, Good Idea!! but I think the ask here is to see only whether the role has been allocated or not. I would prefer 'Boolean formatted ' line item rather a 'Number formatted' as it will consume comparatively very less space and that to in a Employee dimensioned module. Agree/Disagree?

nathan_rudman

I did not see your answer before posting. yours is valid and replies precisely to the "role not used problematic". However being able to count is useful as well, maybe it will help Mark.

for the size, yes boolean is smaller. but here we are talking a module dimensioned by job roles only, maybe time, so extremely small. I used to do all this kind of counting by boolean, but very often you end up having to count as well, so then you need a number format, based on your boolean, which ends up being more space and calcs.

MarkTurkenburg_*8288

Thanks Kavin! - Great solution. Gives me a better understanding of how to use x[ANY:y]

MarkTurkenburg_*8288

Thanks Nathan - definitely useful to know when counting the frequency of occurrence of list items

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…