Using Lists in IF formula

hinamahmood1994

I'm trying to create a formula to say IF 'countries-filter'.'1' LOOKUP[Countries.'UK & ROI' ] THEN 'Actual (Current View)' - 'Forecast (Current View)' ELSE 'Actual (Current View)' - 'Forecast (Previous View)'.

My countries are a list, so i created a Boolean module.

1 - UK

2 - IT

3 -DE

I don't think i've set this module/lookup correctly. The second part of the formula is returning correct values, not the first part. First part is also doing the same as last part of formula.

Accepted answers

DavidSmith

You have time in the boolean module. I suspect you don't need time in this module (unless the logic varies by time) If you are not using time in the downstream model then there is no automatic Top Level item for time as other lists.

The module should just be by the Country list. Also, I appreciate you might be still building, but I would give the 1, 2 and 3 line items more meaningful names. When using booleans I usually add a ? to the end of the line item to signify that is it a boolean check

I hope this helps

David

All comments

DavidSmith

Can you include screenshots of the boolean module?

If your target contains the countries list, you shouldn't need the LOOKUP as it will just directly read from the Boolean module (assuming that is by country too)

David

hinamahmood1994

@DavidSmith

find attached the module for countries

boolean_48075.PNG

DavidSmith

I hope this helps

David

hinamahmood1994

Thank You! Getting rid of the Time in the boolean module fixed the issue. 🙂

DavidSmith

Excellent

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…