-
Forum
-
T24 Technical Discussions
-
T24 Development & Customization
-
Calculate % value
Calculate % value
-
mrul3s
-
Topic Author
-
Offline
-
User is blocked
-
Less
More
-
Posts: 103
-
Thank you received: 0
-
-
-
-
9 years 5 months ago #16484
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.
Less
More
-
Posts: 451
-
Thank you received: 63
-
-
-
-
-
jpb
-
-
Offline
-
Moderator
-
-
TAFj-R20 - 'unix'
Less
More
-
Posts: 2854
-
Thank you received: 649
-
-
-
9 years 5 months ago #16494
by jpb
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
-
Less
More
-
Posts: 103
-
Thank you received: 0
-
-
-
-
-
Forum
-
T24 Technical Discussions
-
T24 Development & Customization
-
Calculate % value
Time to create page: 0.097 seconds