× 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...

Calculate % value

  • mrul3s
  • Topic Author
  • Offline
  • User is blocked
  • User is blocked
More
9 years 5 months ago #16484 by mrul3s
Calculate % value was created by mrul3s
I am creating a main line routine which extract CGT details on excel sheet. my requirement is to calculate TAX amount.

Y.TXT = DROUND(Y.DR.TAX.GAIN * Y.MF.CGT.RATE,4)
Y.TXT.AMOUNT = DROUND(Y.TXT / 100,2)

the value of Y.MF.CGT.RATE in %.
for example 8%
so how we can calculate Y.TXT.AMOUNT

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

More
9 years 5 months ago #16485 by kripesh
Replied by kripesh on topic Calculate % value
Y.MF.CGT.RATE = 0.08

Have a great day !

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

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
9 years 5 months ago #16494 by jpb
Replied by jpb on topic Calculate % value
Do you mean the field contains the % sign ?
Then use e.g. OCONV(Y.MF.CGT.RATE,'MCN') or just strip off the last character Y.MF.CGT.RATE[1,-2]
The following user(s) said Thank You: mrul3s

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

  • mrul3s
  • Topic Author
  • Offline
  • User is blocked
  • User is blocked
More
9 years 5 months ago #16498 by mrul3s
Replied by mrul3s on topic Calculate % value
Thanks...Alot

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

Time to create page: 0.097 seconds