6 Replies Latest reply on Sep 13, 2018 4:51 AM by Zhouyi Zhang

    Calculating daily profits but rent keeps summing up

    Artem Martynov

      Hey! Just starting with Tableu so the question is probably dumb – sorry about that. Couldn't find the answer myself though, because not sure how to phrase the query. So here is the situatoin:

       

      I have daily sales data for three stores and daily rent for all of them.

      Снимок экрана 2018-09-13 в 10.10.06.png

       

      I want to calculate daily profits. So I create a calculated field: Sales minus Rent.

       

      But, since the Rent is in every row, it gets multiplied by the number of sales entries.

       

      So it calculates the whole thing wrong.

       

      Please help me fix this