× 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
  • Junior Member
More
13 years 3 months ago #10764 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.

Please Log in or Create an account to join the conversation.

  • T24User
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
13 years 3 months ago #10766 by T24User
Sorry the result is as follows:

Amt % of total
10 ?
10 ?
10 ?
10 ?
20 ?
20 ?
20 ?
Ttl 100

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
13 years 3 months ago - 13 years 3 months ago #10773 by jpb
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.
Last edit: 13 years 3 months ago by jpb.

Please Log in or Create an account to join the conversation.

More
13 years 3 months ago #10774 by durai611
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.

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
13 years 3 months ago #10775 by jpb
You're right - as always ;-)

Please Log in or Create an account to join the conversation.

  • T24User
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
13 years 3 months ago #10830 by T24User
Thanks guys. I ended up doiing a conversion routine to calculate the totals.

Please Log in or Create an account to join the conversation.

Time to create page: 0.031 seconds