Parenthesis automatically appearing


I am trying to use a custom expression summary (as per the image attached). The equation involves two parts:

= sum(labour_cost)/(sum(places)*average(occupancy))

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!!!

Hi @kacimaiwai
The workaround is to add an addition with zero or something similar to preserve the parenthesis: - upvote by clicking :+1: on the first post
I can see you’re using an older version of Metabase - latest is 0.36.6