-
Adjusting Long Formulas Tip
Since trying to follow long conditional formulas can be tricky within the Anaplan formula bar, a tip to make it easier is to use the Drilldown capability on a cell within the line item. By doing this…5 -
Re: IF CONDITIONAL FORMULAE
Hello Akshay, Would it be possible to use two line items in order to get to your desired result. It appears to me that you would need to be able to enter data under the else clause. Is that correct? …1 -
Re: Today's Date
Hi Leo, Here's the script that I've used that is setup to run as a .bat file. You'll need to just rename the .txt to .bat to convert it back.2 -
Re: Circular Reference with OFFSET function
Ryan, Feel free to use a strict lag/lead in order to avoid having to use the if statement as a solution. Lag Function2