In Perfume Org. We need to do column Techm cost --Total then after put in below formula
and value should be add in the Mist Account Total cost only
If you are trying to use quicksight calculated fields here are a couple of syntax corrections.
instead of if() you need to write ifelse()
For sums, if you are looking to do sum(1,2,3) = 6 then you need to take out the columns and insert math functions. sum(1,2,3) turns into sum(1+2+3).
Also you will need to replace your K3s / J3s with the name of your actual columns.
To have it sum for only the mist account you can also add an ifelse statement at the top : ifelse(account=mist_account, formula,0)
Or you can add a filter on the visual to filter it just to the mist_account.
Hope that helps.