3 Replies Latest reply on Aug 23, 2013 6:28 PM by nelson.r

    How do I make a dynamic calculation according to data entered by the user?


      I am making a simple finacial accounting database and I need to be able to find the sum networth of several accounts together. Every record on a specific layout will be entered with one field having the name of the account wich will be retrieved from the records of a different layout. I can make the calculation manually but i need the calculation to be made automatically according to what account names the user enters into the fields of my sum of acounts networth layout. In another layout I already made a sub-total of every account seperate but i can not figure out or find on google how to make a dynamic formula or calculation to find the joint networth of given acounts. I hope i explained myself, and i would like if someone could tell me if this is possible and how.