I am trying to use a custom expression summary (as per the image attached). The equation involves two parts:
The Labour cost should be divided by the result of the second part of the equation.
However, metabase currently is change the order of the parenthesis so it is calculating the following way:
= (sum(labour_cost)/ sum(places))*average(occupancy)
The parenthesis before "sum(labour_cost) and after “sum(places)” is automatically appearing, and it results in the wrong result.
Does anyone have any advice on how to arrange so the second by of the calculation is indepedent of the first (labour costs)
I have attached a image showing the parenthesis.
Really appreciate any help!!!