Hello @seiu73rojas
Thank you very much for using our plugin. You only need to use the MIN operation. I’ll try to describe the process with a hypothetical equation.
Assuming your current equation is fieldname1+fieldname2, but you want the result won’t be over 80. In this hypothetical case, you should edit the equation as follows:
MIN(fieldname1+fieldname2, 80)
Best regards.
Gotcha! I’m also currently using the PREC decimal limit in the equation. How would I add the MIN aspect to it?
Current eq: PREC(fieldname2*0.0135/fieldname10, 2)
Hello @seiu73rojas
You must use the PREC operation as the outermost operation in the equation:
PREC(MIN(fieldname2*0.0135/fieldname10, 80), 2)
Best regards.
Thank you! Sorry for continuing to pester, but another issue came up. (Hopefully this makes sense.) So, this equation we’re using is for members to figure out how much their dues will be per paycheck. With that said, we have a myriad of options for the number of paychecks that workers typically receive (9-52) in a given year. However, there is a monthly dues cap ($80), which means in certain instances, a single weekly paycheck will result higher than that amount using our formula. For example, a person making $200,000 per year under a typical 26 paychecks per year cycle will pay $103.85 per pay check — higher than the monthly cap.
Is there a way, in those instances where a single paycheck is higher than the cap, to have it result in a figure that takes into account the cap and divides it equally per month? Or something of that sort?
Equation can be found here, form field here.
Hello @seiu73rojas
The solution would depend on the project. If you have a single paycheck (or some paychecks) over the top, I recommend summing all paychecks, dividing the results by the number of payments, and then applying the top to the division result.
I’m sorry, but the support does not cover the development of the users’ projects. If you need someone that implement your project, you can contact us directly via the plugin website. Customization
Best regards.
