Reference form calculation

[jarrod b]

Hello Tapformers,

Ok so I just downloaded Tapforms for IPad and need some help getting set up.

The main form I am using is an inventory with these fields

1. Photo
2. Description
3. Product category
4. Retail price
5. Purchase location
6. Purchase date
7. Sold Y/N
8. Cost price
9. Profit (retail price minus cost price)

I would like to use another form that refers to the inventory form to calculate things like

1. Total profit of sold items
2. Cost price of unsold inventory
3. Average profit percentage
4. Total unsold inventory

How do I go about setting up a form to calculate this information?

Perhaps in the advanced calculation field?

[Author]

Posts