Good morning all,
I am in need of creating a section in the custom form that covers region allocation. And there are five regions we are using and they have to add up to 100 exactly. the logic is the five regions must add up to 100(%) no more/no less.
I thought I could use calculated data in the Custom form, but maybe I am not thinking the right idea.
Any suggestions please?
Hi Maikaru. To ensure the regions add to 100 (percent), and assuming USA is normally the largest, I suggest you use numeric textboxes for CAN, CAP, EMEA, and LATAM, but make USA a calculated numeric parameter with a formula of 100-(CAN + CAP + EMEA + LATAM).
Thank you for expanding on that. I apologize as I am still a little confused and need the exact spelling of each field.
I set it up like this and used your formula, but it comes back as invalid expression.
Would you shed light on the thing that I am doing incorrectly?
Ah! Excellent point, Maikaru. I should have mentioned that you will need to first add the CAN, CAP, EMEA, and LATAM forms to the custom form and then SAVE (so the custom form "knows" those parameters are part of the form) and THEN add the calculated USA parameter. That way, you can then save the USA formula.