cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation between quantity sheets rows

Former Member
0 Kudos

Hi Experts,

If I mention nos of quantity in rows i want to make addition calculation nos of quantity rows to be seen in Total Quantity UDF window. For ex: 20 no given in first quantity row and 10 no given second quantity rows and so on.... 20+10 nos quantity in Total Quantity UDF window.

Accepted Solutions (1)

Accepted Solutions (1)

former_member204969
Active Contributor
0 Kudos

There is no possibility for an FMS to reference more rows of the actual transaction. The standard SQL expressions can access the data already stored in the data base, and the special references (with the $...) can access only the header level and the first row data.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Shailesh......

You can try this...

Select (Select $[POR1.U_UDF1.Number])+(Select $[POR1.U_UDF2.Number])

Just replace UDF1 and UDF2 with your Quantity1 and Quantity2 Fields......

Regards,

Rahul