This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Calculating revenue simple. Error in automatic sum

Posted on 08-02-2024 06:24 PM
lacaja2024
New Member
Reply posted on --/--/---- --:-- AM

I have a little e-commerce. I have two tables in google's sheets, the first one has my purchases and the second one has my sales. I made a connection with looker studio, it's joined by product's name. I'm wiling to calculate how much I've made, my revenue.  This is the equation that I'm using

SUM(Total de venta)-(SUM(Cantidad)*SUM( Precio de compra )

I've added the total purchase sale, after I substract the result of multiplication between the quantity products sold and purchase price, I have a problem with automatic looker studio sum, which shows an incoherent result.

lacaja2024_0-1722647635460.png

I think it's a bug. But I don't know how to solve it. I know every single revenue it's ok, but automatic sum not.

0 1 124
Topic Labels
0 Likes
Reply
1 REPLY 1

Posted on --/--/---- --:-- AM
Spreadsheep
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

could you share a screenshot of what the values of Total de venta, Cantidad and Precio de compra should be for one of your products, so we can see how it's aggregating?

0 Likes
Reply