Respected Sir, Thank You for helping me and guiding me earlier in my doubts. Recently i am making a tdl of Sundry creditors report Amount wise. I am somehow manage to reach some level for completing it but now i am facing some issues due to my lack of knowledge. 1. Hide amount of Group Closing balance but don't want to hide amount of ledger in explode. 2. Sub Total of Exploded Ledger Closing Balance 3. Grand Total of Sub Total Mentioned in Exploded Ledger. Attaching Image and TDL File for your ready referance. I am still a learner, please forgive me if i disrespect you in any manner. Thank You
Good afternoon, Sir, Thanks again for your altered code, i have managed to get Amount by creating duplicate fields and creating subtotal line in explode part. now my only issue is grand total of that sub-totals. i have go thru every thread relating this but i haven't achieved the desired result. Attaching TDL and Screenshot Requesting to all seniors to help me.
Imagine .... imagine.... you have a report without any subtotal ......... means you already have the Collection for all the Ledgers .... but in above you have broken them up Group-wise.... So compute the Grand Total accordingly. Or Else make another Collection for all Ledgers only --- and compute your value and then use $$CollAmtTotal and then use this Total in your field for GRAND Total.
Hello Sir, I have tried everything as per suggestion, i get total if i change main collection from group, but unable to get that total in group. I tried the collection too by creating collection ledger but unable to get success. Please guide me
Make a new collection to get total...... compute the value in that collection.... Leave your original collections as it is......... make a NEW one to compute total values. in system : formulae ---- use $$collamttotal to get the totals.......... fetch this formula in your field.
Still Stuck Sir. I don't know what i am missing, i have done the changes as per your guidance. Attaching tdl for your reference.
Hello Sir, I hope you are doing well. I have somehow reached to the point where i can get total by new collection. now i am stuck to how can i filter the amount based of condition. Attached screenshot and TDL for reference. Hope to get help in this regard.
As a learner you must READ carefully any instructions given....... and follow it properly.......... Make the following changes....... Code: [Line: NBPMTotals] Local : Field : Under15K: Set as : @@Total15E [Collection : SundryCreditorsLedgerTotal] Type : Ledger Child Of : $$GroupSundryCreditors Belongs to : Yes Fetch : ClosingBalance Filter : ZeroClosing Filter : CreditOnly [System:formula] Cond15E : ($ClosingBalance:Ledger:$Name > 0 AND $ClosingBalance:Ledger:$Name <= 15000) Total15E : $$FilterAmtTotal:SundryCreditorsLedgerTotal:Cond15E:$ClosingBalance follow the SAME for the balance columns..............
Good morning sir, Thank you once again to teach me how it's done. I am really grateful for your teaching. I have one doubt. As we are fetching the total from new collection if I hide any creditors group the total amount will not change. Example if the total amount of new collection is 100 and if I hide any group it will still show 100. I know I am making it really long thread. I am really sorry.
First -- the Totals will not change, because you are computing from a dis-associated Collection NOT forming part of your main report. Second - your structure is wrong ..... the sub-totals should be at the GroupLine level rather than at the bottom........ Refer TB and other default reports of Tally.........