I'm trying to calculate the ROI with product revenue and cost, but still given me the wrong value

Question

I'm trying to calculate the ROI with product revenue and cost:

The formula used for ROI

but it gives me the wrong value:

The overview

I tried to use SUM on both sides, but it keep saying that the formula is invalid:

like this

score 0 · Answer 1 · answered Nov 22 '21 at 16:33

0

You can use sum() formula for both columns

answered Nov 22 '21 at 16:33

Govinda Raju

Hey, i tried, bit says the formula is invalid. I put the image on the answer – Matheus Liz Friedrich Nov 23 '21 at 13:26

score 0 · Answer 2 · answered Nov 22 '21 at 18:55

0

Sorry I can't read Portuguese but I believe you need sum() in both sides of your formula, like this:

sum([field 1])/sum([field 2])

answered Nov 22 '21 at 18:55

Romen

Hey, i tried, bit says the formula is invalid. I put the image on the answer – Matheus Liz Friedrich Nov 23 '21 at 13:26

2 Answers2