Skip to Content
0
May 31, 2018 at 02:00 PM

Validation in the formula calculation in the PI sheet .

250 Views

Hi guru's,

Please suggest ,

In the PI sheet , i want the validation to be done for the Calculation formula.

Process characcterisitcs -

0010 PPPI_INPUT_REQUEST - Pallet.1

0020 PPPI_VARIABLE - A

0030 PPPI_REQUESTED_VALUE - ZPT

0040 PPPI_INPUT_REQUEST - Pallet2

0050 PPPI_VARIABLE -B

0060 PPPI_REQUESTED_VALUE - ZPT1

Now by the calculation formula :-

0070 PPPI_INPUT_REQUEST - TOTAL

0080 PPPI_VARIABLE - C

0090 PPPI_CALCULATED_VALUE - ZTOTAL

0100 PPPI_CALCULATION_FORMULA - A +B

0110 PPPI_VALIDATION_FORMULA - C > 10

But the validation formula doesn't have any effect . Validation formula is not working for the calculation.How to add the validation for the formula calculations.

Thank you