experts please help me with formula

Discussion in 'Free Source Codes' started by BATKUMA, May 13, 2018.

    
  1. BATKUMA

    BATKUMA New Member


    AD.png
    [​IMG]i have made a tdl and require help i am attaching the image and the code please help me with formula part
    (a*b)+(c*d)+e+f= total qty
     

    Attached Files:



  2. MSK_Coder

    MSK_Coder New Member


    @BATKUMA

    Just replace the system formula like following line

    QtyCalculation : (#kcnoofpcsprint * #kcmtsprint) + (#kctotalprint * #kcnoofpcs1print) + whatever the filed name just add here

    Incase the field values are empty or zero then you must check with the conditions for that, then you can multiply with other values

    Example :

    Condition1 : if $$IsEmpty:#kcnoofpcsprint OR #kcnoofpcsprint=0 then ($$number:1) else #kcnoofpcsprint

    these kind of conditions only for multiplication wherever you needed,

    For additions does not a problem, you can directly add with the other results or values
     

    Attached Files:



  3. BATKUMA

    BATKUMA New Member


    thank you very much or the reply
    sir i have done that now i have got another problem multiplication is coming incorrect i mean 22.5*2 is 45 its showing 46 in qty colum
    please help me @MSK_Coder@hvpatel@amit kamdar


    please check my file i am uploading to you
     

    Attached Files:

    Last edited: May 14, 2018


Share This Page