Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Please help me in solving this...

syd1980
Level 2
Level 2

Please help me, I'm struggling since morning.

I'm working on form Adobe Livecycle Designer which has a Tax field, I want it to be with only 2 decimals without rounding it off.

I'm using FormCalc and the fields are

Field Names : "SubTotal" and "VAT" (VAT is Calculated-Read Only)

formula using in FormCalc (Calculate) "$=SubTotal*5/100"

Ex: for the amount of 1037.50*5/100 = 51.875

and this give the round off result as 51.88

I want this to be 51.87 (I want the result to be without round off)

 
 

Topics

 
1 Accepted Solution
Kosta_Prokopiu1
Correct answer by
Employee
Employee

If you always want the .87 to show no matter what the 3rd and further digits are, you can do this:

Kosta_Prokopiu1_0-1604914033042.png

This will "cut" after 2 digits, I use the display pattern of num{z,zzz,zz9.99}. I hope that helps.

View solution in original post

2 Replies
BrianKasingli
Community Advisor
Community Advisor

@syd1980 

This question seems to be an AEM Form's question. If you post this same question in the AEM Form's Forum, you will more likely find an answer from there, https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager-forms/ct-p/adobe-experienc...

Kosta_Prokopiu1
Correct answer by
Employee
Employee

If you always want the .87 to show no matter what the 3rd and further digits are, you can do this:

Kosta_Prokopiu1_0-1604914033042.png

This will "cut" after 2 digits, I use the display pattern of num{z,zzz,zz9.99}. I hope that helps.

View solution in original post