turewib
Forum Replies Created
-
Forum: Plugins
In reply to: [Calculated Fields Form] Help with package calculation formHi, thanks but I think something else is wrong. Now I can only get ‘Enterprise’ to output a much too low number (i.e. multiplying is wrong), but I’m unable to figure out why.
Forum: Plugins
In reply to: [Calculated Fields Form] Help with package calculation formThanks! This works realy well, only I can’t seem to get an output for ‘Enterprise’ for some reason? It will display the N/A just fine, but no calculation result (which works great for Basis and Pro). Ideas?
Forum: Plugins
In reply to: [Calculated Fields Form] Help with package calculation formHi, the original question was answered above, but I now realize we have additional complexity to figure out, and that I need help with.
Example:
Number of employees: 100
Package: BasisThe calculation above uses a ‘stepped’ price range, where all 100 employees will cost 120, i.e. a total price of 12000.
What we need is for the first 74 to cost 150, and the remaining 26 to cost 120, i.e. a total price of 11100+3120=14220
In Excel the formula will be something like this:
=IF(B6>=C2;((B6-C2)*D3+C2*D2);”N/A”)Forum: Plugins
In reply to: [Calculated Fields Form] Help with package calculation formHi, thanks! This makes perfect sense, and works like a charm.