I have two issues I am trying to solve. Company123 has a budget of 706.34, but there was no $ for this week. The cell is blank, so my formula is not calculating. The Budget GP-GP should equal -706.34, but it is blank. Can I do a Beast Mode, or even something in the ETL would be okay?
Second issue is the 27,504.75 minus -77,584.85 should equal -50,080.10, but it is showing 105,089.60. Is there a better Beast Mode Formula I can use?