Hi all,
My report LEFT JOINs proj_budget_control_rules to project, so projects with no budget rule at all still appear with combination_id null, and Get_Control_Total/Get_Consumed return 0 for them — same as a project with an actual $0 budget.
Is there a clean way to tell "no budget rule exists" apart from "budget rule exists with $0 consumed"? E.g. filtering on NULL combination_id before calling the API, or a status field on proj_budget_control_rules I should be checking instead. I’ve also tried adding funds and it just wont update haha.
Thanks!