syd1980
10-09-2020
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
Kosta_Prokopiu1
Employee
09-11-2020
If you always want the .87 to show no matter what the 3rd and further digits are, you can do this:
This will "cut" after 2 digits, I use the display pattern of num{z,zzz,zz9.99}. I hope that helps.
BrianKasingli
MVP
08-11-2020
@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...