Getting beast mode to calculate 10% value of a column
Hello Domo masters,
I am trying to build a card that would display projects in a table when the following criteria is met:
1. Approaching budget (Actuals >90% of Budget)
2. Over Budget (Actuals > Budget)
I tried the following calculation in testing:
When `Project Actuals YTD` >= ((`New Budget`+`Rollover Budget`) * .90) then 'Approching Budget'
When `Project Actuals YTD` > (`New Budget`+`Rollover Budget`) then 'Over Budget'
The result I am getting is as follows:
Projects that are over budget are shown accurately but the Beast Mode calc column only displays 'Approaching budget' for all projects rather than what is intended by the calculation. The projects at this moment should show 'Over Budget' rather than 'Approaching Budget'.
i am thinking the * .90 could be not a valid calculation?
Any insite would be much appreciated.