Skip to main content
Microsoft Dynamics NAV forum
Answered

Calculate Amount ??

editSubscribe (0) ShareShare
ReportReport
Posted on by 768

Hi Experts,

i have custom document page i want to calculate Amount.

Amount field are in the line table and Total Amount field are also in the line table.

i want to calculate only those Amount which "Document No." = "No."

Total Amount := sum(amount) where "Document No" = "No".

"No." is a header Primary key and the "Document No." field are the header field in the line table.

Note: all the fields are in the line table 

  • Verified answer
    RE: Calculate Amount ??

    yes you are right sir but the total field are also in line and the problem solved 

    here is the solution 

    FieldClass = FlowField;
    CalcFormula = sum ("DLX Event Registration Lines".Amount where ("Document No." = field ("Document No.")));
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,152 on at
    RE: Calculate Amount ??

    As written above, create a flowfield on the Header table that sums the amount field you want (I don't know what is the amount field you want to sum) for all the lines related to the header table.

  • RE: Calculate Amount ??

    yes you are right but here the total field are in the line table and the amount are also in the line table 

    1 Total Amount ( Tab Line).

    2 Amount ( Tab Line).

    i want to calculate the amount on condition 

    To calculate the amount for all those line which which are link with header.

    3 Header and Line Relationship

    Header "No." and Line "Document No"  

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,152 on at
    RE: Calculate Amount ??

    I've not understood the question, sorry. You can create a flowfield on the header table with the CalcFormula = what you have written (sum(YourLineTable.amount) where YourLineTable."Document No" = "No".)

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans