Skip to Content
0
Former Member
Nov 02, 2012 at 01:14 PM

SQ01 : Percent Formula (Local Field) Value not correct

755 Views

Hi Guru,

i am try to create a Report for the Production Variance Analysis in term of

Component Quantity - Required and Withdrawn

i use two field as local field for the as;

FIELD FORMULA REMARKS

  • VAR_QTY B - A Where 'A' is Required Qty, and 'B' is Withdrawn qty, and its output value is OK (169.585)
  • VAR_PER (VAR_QTY / A ) * 100 This is for difference value in Percent (%), but is system giving out 0.000, instead of (3.972)

additional setting of 'VAR_PE' is shown in Screen shot.

Additional Information:

Table -

Order item - AFPO

Resevation Dependent Requirement - RESB

Material Description - MAKT

pls revert ASAP, thanks in Advance

regards

Muhammad Shoaib

Attachments