Calculation filed to bring the result

Hi,

I have have issue on how can I make this work in CB. I am new to CB and not a good skill in programming. I have create few field (cb_saving & cb_sharing_profit)

I wanted to check, can CB work on this way of the calculation? how can I do this?

user1 saving = $10
user2 saving = $20
user3 saving = $10


cb_total_saving= $40
cb_total_user = 3

cb_sharing_profit = $120 (the calculation = cb_total_saving ($40) + cb_total_user (3))

Really appreciate if you can help me on this.

You need CB Query Field or CB Code Field to do that using either SQL or PHP to add their values together.