nkranker Member

Comments

  • Hi Thank you for you reply/solution. It's a bit more complicated since two of the four columns calculated are through beast modes. So if NULL I need to replace with that same beast mode. Unsure if this causes some circular error. The below formula was validated however when putting in as a filter, an error came up that…
  • Hi GuitarHero23, Thanks, I did take your suggestion ans worked it with our current beast modes for 2016-17 revenue, costs, GM & GP. The last two are tricky since if GM or GP IS NOT NULL then it need to be the beast mode for th GM & GP as it's replacement since these two were manually calculated (not in the dataset). In…