I want to minus(-) the field vlue of grosswgt,lesswgt and put the value in Netwt, pls help in frmula

Discussion in 'Free Source Codes' started by Rohit001, Jan 14, 2020.

    
  1. Rohit001

    Rohit001 Member


    [#Line: EI ColumnOne]

    Option : sms EI ColumnOne : @@IsSales

    [!Line : sms EI ColumnOne]

    Add : Right Fields : Before: VCH QtyTitle :GRWT ,LESWT, NTWT, TNCH
    Local : Field : GRWT : Info : "Gross Wt."
    Local : Field : LESWT : Info : "Less Wt."
    Local : Field : NTWT : Info : "Net Wt."
    Local : Field : TNCH : Info : "Tunch"
    [#Line : EI InvInfo]

    Option : sms EI InvInfo : @@IsSales

    [!Line : sms EI InvInfo]

    Add : Right Fields : After : VCH ActualQty : GRWT,LESWT, NTWT, TNCH


    [Field : GRWT]

    Use : Number Field
    Type : Number : Forced
    Storage : smsgrwt
    Set as : ""
    Width : 10
    Align : Center
    Format : "NoZero"
    [Field : LESWT]

    Use : Number Field
    Type : Number
    Storage : smsleswt
    Set as : ""
    Width : 10
    Align : Center

    Format : "NoZero"

    [Field : NTWT]

    Use : Number Field
    Type : Number: Forced
    Storage : smsnetwt
    Set as :mad:@NET
    Width : 10
    Align : Center
    Format : "NoZero"


    [Field : TNCH]

    Use : Name Field
    Type : String : Forced
    Storage : smstunch
    Set Always : Yes
    Width : 10
    Align : Center
    Format : "NoZero"

    [System:Formula];;;;; formula;;;

    NET: $smsgrwt-$smsleswt

    [System : UDF]
    smsgrwt : Number : 702
    smsleswt : Number : 701
    smsnetwt : Number : 705
    smstunch : String : 709
     

    Attached Files:



  2. Rohit001

    Rohit001 Member


    Please help sir!
     


  3. Rohit001

    Rohit001 Member


    Thankyou sir!
     


Share This Page