calculated fields

[kzychu]

hi!

I have a data in one table:
date, amount, cost
2024-10-01, 100, 20
2024-10-03, 100, 25

I am showing that data in the table in Looker and adding new calculated field ROAS = amount/cost:
date, amount, cost, ROAS
2024-10-01, 100, 20, 5
2024-10-03, 100, 25, 4

I want to have a summary, but not as a SUM of all fields, but SUM(amount), SUM(cost) and ROAS as a SUM(amount)/SUM(cost)

How I can do that?

[Mehdi_Oudjida]

@kzychu 

You should replace the formula of your calculated field by SUM(amount)/SUM(cost). It is the good way to go for reach row and the summary calculation.

Mehdi