on 09-13-2011 5:24 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.