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
yes you are right sir but the total field are also in line and the problem solved
here is the solution
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.
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"
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".)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
288,584
Super User
#2
Martin Dráb
225,864
Super User
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (