1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

can some change this formula for alternative unit total

Discussion in 'Requests' started by bikash agarwal, Mar 10, 2018.

    
  1. bikash agarwal

    bikash agarwal Member


    can some change this formula for alternative unit total or both e.g -- first quantiy then alt. quantity in bracket;);)

    [ System : Formula ]

    TotalQty : $$Owner:$$CollQtyTotal:InventoryEntries:$Billed Qty

    [Line:OTSAmountinPord]
    Field: Medium Prompt, Name Field
    Local: Field: Medium Prompt: Set as: "Total Quantity -"
    Local: Field: Medium Prompt:Style:p9
    Local: Field: Name Field: Set as: $TotalQty
    Local: Field: Name Field: Full Width: Yes
    Local: Field: Name Field: Line:0
    Local: Field: Name Field:Style:p10
    Space Top:0.5
    Space Bottom:0.5
     
    bikash agarwal, Mar 10, 2018
    #1


  2. bikash agarwal

    bikash agarwal Member


    here is the pic
     

    Attached Files:

    bikash agarwal, Mar 10, 2018
    #2


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Set As : $TotalQty + "(" + $AlternateQty + ")"

    Also Define Alternate Qty in System:Formula..............same as u did for Total Qty
     
    Amit Kamdar, Apr 25, 2018
    #3


  4. bikash agarwal

    bikash agarwal Member


    but not comming i want quantity and alternative quantity side by side--- e.g -- "total quantity -- 20000 ltrs ( 10 pcs ) " in this format

    here is the code :


    [ System : Formula ]

    TotalQty : $$Owner:$$CollQtyTotal:InventoryEntries:$Billed Qty


    [Line:OTSAmountinPord]
    Field: Medium Prompt, Name Field
    Local: Field: Medium Prompt: Set as: "Total Quantity -"
    Local: Field: Medium Prompt:Style:p9
    Local: Field: Name Field: Set as: $TotalQty
    Local: Field: Name Field: Full Width: Yes
    Local: Field: Name Field: Line:0
    Local: Field: Name Field:Style:parth SET Name
    Space Top:0.5
    Space Bottom:0.5
     
    bikash agarwal, Apr 26, 2018
    #4


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Read carefully again....and then do it....


    Set As : $TotalQty + "(" + $AlternateQty + ")"

    Also Define Alternate Qty in System:Formula..............same as u did for Total Qty
     
    Amit Kamdar, Apr 26, 2018
    #5


  6. bikash agarwal

    bikash agarwal Member


    i am new at TDL you please arrange for me the TDL code....


    [ System : Formula ]

    TotalQty : $$Owner:$$CollQtyTotal:InventoryEntries:$Billed Qty


    [Line:OTSAmountinPord]
    Field: Medium Prompt, Name Field
    Local: Field: Medium Prompt: Set as: "Total Quantity -"
    Local: Field: Medium Prompt:Style:p9
    Local: Field: Name Field: Set as: $TotalQty
    Local: Field: Name Field: Full Width: Yes
    Local: Field: Name Field: Line:0
    Local: Field: Name Field:Style:parth SET Name
    Space Top:0.5
    Space Bottom:0.5
     
    bikash agarwal, Apr 26, 2018
    #6


Share This Page