I’m looking to create projection columns for each month of the year by taking the Value column divided by the Duration (In Months). I’d like this column to be $0 if a project isn’t expected to start yet or has already ended which is why I included two date related conditions using Start Date and End Date. Unfortunately, I’m getting an Invalid Formula Error; has anyone found a fix for something similar? Not sure what I’m missing! Thanks in advance!
