× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

How to sum up values in Enquiry

Start
Prev
1
Next
End

ORLY01
Topic Author
Offline
Junior Member

5 years 11 months ago #22285 by ORLY01

How to sum up values in Enquiry was created by ORLY01

I created new enquiry based on CATEG.ENTRY.
I would like to sum up the AMOUNT.LCY and AMOUNT.FCY and display it in the buttom.
Note - the user can enter range of dates and according to that, values will be presented (including the total value).

How can i do that?

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

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

5 years 11 months ago #22289 by VK

Replied by VK on topic How to sum up values in Enquiry

Hi
Refer to help text of the fields FIELD and DISPLAY.BREAK.

Another issue - Temenos doesn't recommend to create enquiries on CATEG.ENTRY - it can run forever :))

Cheers
VK

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

ORLY01
Topic Author
Offline
Junior Member

5 years 10 months ago #22290 by ORLY01

Replied by ORLY01 on topic How to sum up values in Enquiry

Thanks!
Do you have another idea of how to calculate the accrued interest?

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

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

5 years 10 months ago #22291 by VK

Replied by VK on topic How to sum up values in Enquiry

Hi
what about accrued interest? Nothing about that in this post...

Cheers
VK

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

ORLY01
Topic Author
Offline
Junior Member

5 years 10 months ago #22292 by ORLY01

Replied by ORLY01 on topic How to sum up values in Enquiry

The reason we created this enquiry is to present the accrued interest of a selected range of dates.
That is why we sun up the amounts in the CATEG.ENTRY

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

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

5 years 10 months ago #22293 by VK

Replied by VK on topic How to sum up values in Enquiry

Hi
have you looked at:

help text of the fields FIELD and DISPLAY.BREAK

Cheers
VK

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

ORLY01
Topic Author
Offline
Junior Member

5 years 10 months ago #22294 by ORLY01

Replied by ORLY01 on topic How to sum up values in Enquiry

Sorry, I was not clear...
You mentioned that Temenos doesn't recommend to create enquiries on CATEG.ENTRY, do you have any idea of how to display this data (according to a selected range of dates) without the CATEG.ENTRY? including data from the past

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

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

5 years 10 months ago #22295 by VK

Replied by VK on topic How to sum up values in Enquiry

Hi

Take a look at Fxxx.CATEG.ENT.ACTIVITY, where xxx is your company mnemonic.

Cheers
VK

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

ORLY01
Topic Author
Offline
Junior Member

5 years 10 months ago #22297 by ORLY01

Replied by ORLY01 on topic How to sum up values in Enquiry

What exactly is Fxxx.CATEG.ENT.ACTIVITY?
enquiry? APP? tables?

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

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

5 years 10 months ago #22301 by VK

Replied by VK on topic How to sum up values in Enquiry

A table.

Cheers
VK

The following user(s) said Thank You: ORLY01

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

Start
Prev
1
Next
End

Time to create page: 0.044 seconds