Hello Sir, I am new to learning TDL and need your guidance. I am creating a report where I want to show data based on closing amount less than specific amount. I.e. if closing balance is less than 15000 then it shows in under 15000. If closing less than 100000 then it shows in under 1Lakh. Please help me in this regard. Thank you
Thank You sir for your prompt reply. I have made a file based on your suggestions, but still unable to achieve the output due to my understanding. Attaching file for your reference. Your kind suggestions will be helpful.
You have columnar, so use conditional formula.......... e.g. if $ClosingBalance > 100000 AND $ClosingBalance <= 500000 and so on........for all the columns. Learn a little bit about formulas from Developer, it will help you to learn on how to CONSTRUCT the formula.
Wow Sir, Thank You So Much once again. For helping me in this matter. I will surely follow your instructions and learn more about it. I really have a respect for you.
Thank You so Much Sir for your guidance. This is my first TDL which i have created with the help of you and other experts. Attached Image and Code file. I may have use wrong conditions for my results but its working right now. Please share you kind reviews and thoughts about it.
Good of you to make efforts and learn. Keep it up. Also take care to understand the type of DATA...... here you are converting number/amount to string. Just in case if one need to have a total or to have a further computation of such report,, then it will not help. So it always help to use the appropriate Data Type in your Fields.
Good Evening Sir, Sorry for the Late Reply. Thank you sir for your great teaching. I have made some changes in my data as per your teaching. Attaching TDL for your reference. Please guide me sir if anything i can add or make changes. Thank You once again.