cancel
Showing results for 
Search instead for 
Did you mean: 

Quantity sheets calculation

Former Member
0 Kudos

Hi Experts,

I have added new field name" Quantity Sheets" in Purchase Order. I want to make calculation so that the per Quantity Sheets to be added with Unit Price field. Could you help me with the formula? Please guide me regarding this.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Shailesh......

try this......

IF $[$39.5.Number] > 0
SELECT $[$39.U_Quantity.Number]*$[$39.5.Number]

Regards,

Rahul

Edited by: RAHUL MOUNDEKAR on Sep 13, 2011 8:58 PM

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

create a FMS for your price.

quantity sheets plus what field?

Addition of quantitysheet + whatfield


select cast($[POR1.U_quantitysheets]  as numeric(19,2)) + cast($[POR1.WhatFIELD] as numeric(19,2))

Multiply quantitysheet X whatfield

 
select cast($[POR1.U_quantitysheets]  as numeric(19,2)) * cast($[POR1.WhatFIELD] as numeric(19,2))

note: change POR1.U_quantitysheets into your actual UDF name for quantity sheets and alod POR1.WhatField.

Then place it under your Price field in POR1.

Regards,

Darius