Avg Not Updating In Item Monthly Summary

Discussion in 'Tally Developer' started by HAROON2015, Oct 2, 2019.

    
  1. HAROON2015

    HAROON2015 Member


    please advice me to correct this code
    it is showing the same avg for multiple fields for multiple stock item

    Code:
    [#Field: DSPQ GPPercTitle]
    Info: $$LocaleString:"AVG"
    Invisible: NO
    Align:RIGHT
    STYLE:small BOLD
    COLOR : BLUE
    
    [#Field: DSP GPPerc];[#Field: DSPGPAMT]
    Use         :DSP RateTemplate
    Set as      :$$Total:DSPCrAmtA / $$Total:DSPOutQty
    Style       : if ($TrAvgPurcCost != $TrAvgPurcPrice) then "Small Bold Italic" else "Small Italic"
    Inactive    : No
    Invisible   : no
    color : red
    style:normal bold
    
    [#Field: DSP StkColTotalTotal]
    Local:Field:DSP GPPerc:Set as:$$Total:DSPCrAmtA / $$Total:DSPOutQty
    [​IMG]
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I think the field name is DSPNettCrAmtA
     


  3. HAROON2015

    HAROON2015 Member


    This is the full code sir
    Actually i just modified the field:DspGpPerc
    To get the average of the amount / qnt

    But i am not getting the result what i want,

    If i use
    Use:Simple Field
    Or
    Use:Simple Prompt
    Or
    Use:Simple amount field

    Then what effect will comes to my report

    Thanks for the reply
     


  4. HAROON2015

    HAROON2015 Member


    This is the full code sir
    Actually i just modified the field:DspGpPerc
    To get the average of the amount / qnt

    But i am not getting the result what i want,

    If i use
    Use:Simple Field
    Or
    Use:Simple Prompt
    Or
    Use:Simple amount field

    Then what effect will comes to my report

    Thanks for the reply
     


Share This Page