Forum Discussion

Spotto's avatar
Spotto
Helper IV
3 years ago
Solved

FORMULA DIVIDE PRODUT

hello everyone, I need to create a formula that takes the value of column 1 (1) and divides it by the number of CONTRATO so that adding the result per contract results in the number 1 again.

 

RESULT:

I did it by duplicating the table, adding and relating between it, but I think it's possible to optimize with some formula or measure

 

thanks for the help in advance

 

Need Help

3 Replies

  • davehus's avatar
    davehus
    Memorable Member
    3 years ago

    Hi Spotto ,

     

    Please find the solution attached. 

     

    Hope this helps.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

     

      • davehus's avatar
        davehus
        Memorable Member
        3 years ago

        Thank you, please accept my solution if it works. 🙂