nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

currentcy format issue for loss or negative values

Atar Singh

Hi,

In mycurrent report,I have to set currency as($ 1000) for negative vlaues. While i ended up showing
like $(1000) .

Could you please suggest,How can i show loss or negative values like ($ 1000) ?

Thanks,

Atar Singh

Find more posts tagged with

Comments

mwilliams

One thing you could do would be to create a computed column in your dataSet that creates a string representation of your currency values for display in your report. Something like:

if (row["myRow"] < 0){
"($ " + row["myRow"].toString() + ")";
}
else{
row["myRow"].toString();
}

Or something like that. You can still do any other computations with your original field.

Suneel Mac

It is working fine for only data set columns... I need the same format for aggregation also...

Could you please suggest,How can i show?

mwilliams

Delete the aggregation element and use a text or dynamic textbox instead to format the display of your aggregation value.

Atar Singh

Thanks a lot, This issue is resolved.

Atar Singh

Solution :

I did not use any script rather,

1. Selected "Format Number"
2. Format as "Custom" and in
3. Format Code added "($##,##0)"

Thanks,

Atar Singh

mwilliams

Not all numbers had the () around them with that format? Just the negatives? If so, I learned something new today! I thought about that but figured it would show the () for all values.