validate key figure

[Former Member]

hi gurus.

i have a layout (on web) where the user has to enter 5 percentages values for diferrent 5 accounts in 0quantity key figure, but the thing is that this 5 values must acumulate a total of 100%, how can i validate this?

regards

[Former Member · Accepted solution]

Your requirement would have been standard in BPS , but in IP(Web), you will have to write a small fox formula which adds these 5 accounts. You should link this function to the save button and this function should be executed before the save command so that you can check and give appropriate messages before saving.

Hope this helps.

Cheers

Raghu

[Former Member]

Hi,

are you working with IP? If so one comparatively easy possibility is to create a fox coding which sums up the entered values and validates if the sum is equal to 100%. After this validation you can work with messages depending on a successful or unsuccessful check you can display either information- or warning- or error messages.

Brgds,

Marcel

[Former Member]

Hi,

why don't you let the user enter 4 values and compute the 5th value in a planning function. This way you can be shure to have 100%.

Hope this helps.

Matthias