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
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.
@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
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.
