Have 5 dropdowns that will do a average calculation and any fields that have N/A selected I want totally out of the average and not even counted at all. Average is working perfect but not sure how to go about getting the N/A fields out of the average calculation
Yes, you can define at the event level which scripting language to use. So, the same field can have different events like click, calculate, mouseEnter, etc. with different scripts in different languages. If you want to do all the calculations in the 'calculate' event, you probably need to use the same scripting language. If you are passing the field values in from somewhere else, maybe you can put in some scripting in the initialize event to strip out the 'N/A' fields before the calculate in invoked.