cancel
Showing results for 
Search instead for 
Did you mean: 

How to use Round off function in TAX Formula

Former Member
0 Kudos

Dear All,

I have to do Round off in the Tax Formula. Hence I was suggested by the SAP Forum Team to use Round off function in the Tax Formulae.

But sir I don't know how to use Round off function in the Tax Formulae.

For Eg. BaseAmt = Total

TaxAmt = BaseAmt * Rate

Now within this Eg. How will i use the Round off function and where i will use it.

Please guide me with example.

Regards

Hitesh Parsawala

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Hitesh,

TaxAmt = Round(BaseAmt * Rate,0) ..... Rs70.00

TaxAmt = Round(BaseAmt * Rate,1) Rs.70.10

TaxAmt = Round(BaseAmt * Rate,2) Rs.70.12

This digits at the end indicates the round upto digits after decimal.

Hope this will help you.

Regards,

Abhishek

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Hitesh,

you can do like this

Cess_ST_TaxAmt=Round(Cess_ST_BaseAmt*Cess_ST_Rate,0)

where you can introduce rounding function by choosing from dropdown available in Operation and by click on Insert.

It will post following in formulla window

Round (Number, Decimals as Number)

where in parameter you have to give 1.Number-which is to be round and 2.Decimals as Number-as per your requirement like by 2 decimal or 0 decimal

If required give me call,

BR

Samir Gandhi