Changing number format using custom format.

Question

Hello,

I have a global percentage and several rows with prices. I'd like to have a column next to them with the prices with the percentage applied to them, which is easy to do, but you end up with lots of 0.00 values if a certain row doesn't have any prices.

To solve it I'm using the following format script I found here:

event.value = (event.value != 0)?util.printf("€ " + "%,0.2f",event.value):"";

The problem is that it formats using a dot (100.00) for decimals, and I'd like a comma (100,00) but have no idea how to accomplish that.

If you have any tips I'd greatly appreciate it.

Nesa Nurani · Accepted Answer

Change 0 to 2:event.value = (event.value != 0)?util.printf("€ " + "%,2.2f",event.value):"";0 — Comma separated, period decimal point1 — No separator, period decimal point2 — Period separated, comma decimal point3 — No separator, comma decimal point

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded