nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Formula - Yes, no, n/a

CommunityMember113484

Hi,

How do I build a formula which states if a = b, then "not required", if a > b, then "yes", and if a < b, then "no".

Thanks in advance

Accepted answers

jackcplanning

Hi @CommunityMember113484 ,

A simple IF statement may be what you're looking for:

IF a = b THEN "not required" ELSE IF a > b THEN "yes" ELSE "no"

Please keep in mind, to optimize the formula, place the earliest exit first.

All comments

jackcplanning

Hi @CommunityMember113484 ,

A simple IF statement may be what you're looking for:

IF a = b THEN "not required" ELSE IF a > b THEN "yes" ELSE "no"

Please keep in mind, to optimize the formula, place the earliest exit first.

SandeepB

@CommunityMember113484 ,

There are several ways you can technically achieve this.

However, I would like to understand what is "a" and "b" in your statement?

Number formatted line items without any dimensions? if so, your formula looks something like this: if a=b then "not required"(text formatted line item) else if a>b then "yes" else "no"

Let me know if that helps.

Thanks,

Sandeep

CommunityMember113484

Thanks, worked great!

Quick Links

Can you help?

Unanswered questions

Reverse Lookup for a List to List Mapping (more than one mapping)
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
explainability results is blank into model
Why in my model output is blank, after send explainability data.