I've created a simple form with inputs for Cost & Profit. I added two fields for Percent Profit and Price but want those to be calculated from the Cost and Profit entries. The calculation is simple and would be a no brainer in Excel, but I can't figure it out using the Help file alone.
Percent Profit = Profit / Cost
Price = Profit + Cost
I'm sure I can get it if I could see some examples of simple forms that do calculations. Or even a detailed walk through would be nice. The Help file would be so much more "helpfl" if it showed a few pictures on where some of these functions are hidden. lol...
Thanks Zero. I'd like to see an example of this. What it sounds like is I bind a name to each field I want to use in the calculation.
1. So under the "Binding" tab I enter a name for each object who's value is used or calculated.
2. Then in the object I want calculated I set its value type to "Calculated-Read Only."
3. Now I'm lost... where do I enter the formula? I tried entering "ProfitPercent.rawvalue = Profit.rawvalue / TotalCost.rawvalue;" in the "Default Binding" but that gave me an error "failed to generate...see log tab/" I love that... now I can't find the log tab.
It took me hours just to find the Object tab....heh heh.
My email address is Jim19596 "at" hotmail.com.
My next question will be "How do I export the data from the form into an Excel spreadsheet row?"