Custom Module - calculate percentage of two fields
I have a Custom Module in CRM that enables sales people to create a record per month to log some metrics against targets. I have managed to get the form to calculate their targets basked on working days per month - but the output of these fields is not shown on creation or updating.
I want to create a field that calculates the percentage of their target that has been met, but using the Target fields mentioned above and also the totals sent that have been calculated in a sub-form. The problem is, that the target results field is not a listed as a field when trying to create the formula. I then want to be able to run a report and a Chart that displays these in a useful graphical format.