- Forum
- T24 Technical Discussions
- T24 Installation & Configuration
- URGENT!!! Enquiry- Display ttl percentage per line
×
Discuss on T24 Installation, Setting up the environment, TC Server, jBOSS, Package & Deployment, etc…
URGENT!!! Enquiry- Display ttl percentage per line
- T24User
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 26
- Thank you received: 0
13 years 3 months ago #10764
by T24User
URGENT!!! Enquiry- Display ttl percentage per line was created by T24User
Hi All Enquiry Experts!!
I am in urgent need of some assistance to meet a tight delivery deadline so please advice.
I am calculating the total of each line and displaying as a page break in a T24 Enquiry at the end, which is working fine. I then want to calculate the % total per line. So What I need to do is once I have got the total (100 as below), divide it by each line i.e for each line - first line (10/100) * 100, giving me a perc of 10%, and do the same for each line. I have tried a few things but it is not working. The relevant enquiry record is as follows:
Enquiry result:
Grp Amt % of total
accs 0
10.00
10.00
10.00
10.00
10.00
10.00
20.00
20.00
AcctsTtl 120.00
Enquiry Rec:
14.32 FIELD.NAME..... AMT.100
15.32. 1 OPERATION... "100"
14.48 FIELD.NAME..... VALUE.REF.CCY
15.48. 1 OPERATION... VALUE.REF.CCY
16.48 COLUMN......... 9
17.48 LENGTH.MASK.... 19R
20.48 TYPE........... CCY LCCY
22.48. 1 GB FIELD.LBL Amt
23.48 FIELD.DISP.TYPE CLASS-AMNUM
35.48 SINGLE.MULTI... S
14.50 FIELD.NAME..... TTL123
15.50. 1 OPERATION... TOTAL VALUE.REF.CCY
14.70 FIELD.NAME..... PERC.TTL
15.70. 1 OPERATION... CALC VALUE.REF.CCY / TTL123
14.71 FIELD.NAME..... DISP.PERC
15.71. 1 OPERATION... CALC PERC.TTL * AMT.100
16.71 COLUMN......... 17
17.71 LENGTH.MASK.... 15R
20.71 TYPE........... CCY LCCY
22.71. 1 GB FIELD.LBL % of total
23.71 FIELD.DISP.TYPE CLASS-AMNUM
Thanks in advance for your help.
I am in urgent need of some assistance to meet a tight delivery deadline so please advice.
I am calculating the total of each line and displaying as a page break in a T24 Enquiry at the end, which is working fine. I then want to calculate the % total per line. So What I need to do is once I have got the total (100 as below), divide it by each line i.e for each line - first line (10/100) * 100, giving me a perc of 10%, and do the same for each line. I have tried a few things but it is not working. The relevant enquiry record is as follows:
Enquiry result:
Grp Amt % of total
accs 0
10.00
10.00
10.00
10.00
10.00
10.00
20.00
20.00
AcctsTtl 120.00
Enquiry Rec:
14.32 FIELD.NAME..... AMT.100
15.32. 1 OPERATION... "100"
14.48 FIELD.NAME..... VALUE.REF.CCY
15.48. 1 OPERATION... VALUE.REF.CCY
16.48 COLUMN......... 9
17.48 LENGTH.MASK.... 19R
20.48 TYPE........... CCY LCCY
22.48. 1 GB FIELD.LBL Amt
23.48 FIELD.DISP.TYPE CLASS-AMNUM
35.48 SINGLE.MULTI... S
14.50 FIELD.NAME..... TTL123
15.50. 1 OPERATION... TOTAL VALUE.REF.CCY
14.70 FIELD.NAME..... PERC.TTL
15.70. 1 OPERATION... CALC VALUE.REF.CCY / TTL123
14.71 FIELD.NAME..... DISP.PERC
15.71. 1 OPERATION... CALC PERC.TTL * AMT.100
16.71 COLUMN......... 17
17.71 LENGTH.MASK.... 15R
20.71 TYPE........... CCY LCCY
22.71. 1 GB FIELD.LBL % of total
23.71 FIELD.DISP.TYPE CLASS-AMNUM
Thanks in advance for your help.
Please Log in or Create an account to join the conversation.
- T24User
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 26
- Thank you received: 0
13 years 3 months ago #10766
by T24User
Replied by T24User on topic Re: URGENT!!! Enquiry- Display ttl percentage per line
Sorry the result is as follows:
Amt % of total
10 ?
10 ?
10 ?
10 ?
20 ?
20 ?
20 ?
Ttl 100
Amt % of total
10 ?
10 ?
10 ?
10 ?
20 ?
20 ?
20 ?
Ttl 100
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
13 years 3 months ago - 13 years 3 months ago #10773
by jpb
Replied by jpb on topic Re: URGENT!!! Enquiry- Display ttl percentage per line
maybe this doc from G15 will help you clarify how TOTAL works in ENQUIRY.
--> send me your E-mail, it's impossible to attach the zipped doc; hope GvA will improve this a.s.a.p.
--> send me your E-mail, it's impossible to attach the zipped doc; hope GvA will improve this a.s.a.p.
Last edit: 13 years 3 months ago by jpb.
Please Log in or Create an account to join the conversation.
- durai611
- Offline
- Elite Member
-
Less
More
- Posts: 300
- Thank you received: 51
13 years 3 months ago #10774
by durai611
Replied by durai611 on topic Re: URGENT!!! Enquiry- Display ttl percentage per line
Hi,
I doubt it's not possible to calculate the percentage for each line with set up in Enquiry record, since total holds only the value of that current+previous line value as shown below
10 10/10*100
10 10/20*100
10 10/30*100
Try for NOFILE enquiry.
Dear jpb, correct me if my understanding is wrong.
I doubt it's not possible to calculate the percentage for each line with set up in Enquiry record, since total holds only the value of that current+previous line value as shown below
10 10/10*100
10 10/20*100
10 10/30*100
Try for NOFILE enquiry.
Dear jpb, correct me if my understanding is wrong.
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
13 years 3 months ago #10775
by jpb
Replied by jpb on topic Re: URGENT!!! Enquiry- Display ttl percentage per line
You're right - as always ;-)
Please Log in or Create an account to join the conversation.
- T24User
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 26
- Thank you received: 0
13 years 3 months ago #10830
by T24User
Replied by T24User on topic Re: URGENT!!! Enquiry- Display ttl percentage per line
Thanks guys. I ended up doiing a conversion routine to calculate the totals.
Please Log in or Create an account to join the conversation.
- Forum
- T24 Technical Discussions
- T24 Installation & Configuration
- URGENT!!! Enquiry- Display ttl percentage per line
Time to create page: 0.031 seconds