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 New 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 New Member


    Please help sir!
     


  3. Vikram Bhat

    Vikram Bhat Member


    Change it


    [Field : NTWT]

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


  4. Rohit001

    Rohit001 New Member


    Thankyou sir!
     


Share This Page