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; } } }

Report amounts divided by 1000?

Sylvia Cook

Is there a setting to have a report print amounts by 1000s?

Find more posts tagged with

Comments

Kevin Brazell

@Sylvia Cook , on most reports, there are,check the numbers format settings for 1,000 comma, and make sure it has a check mark in it. In database view it would be on the Format tab itself.

Sylvia Cook

@Kevin Brazell
Thanks for replying Kevin. That adds the comma for 1000 to be 1,000. I am looking to have a way to have all amounts divided by 1000… could say round to the 1000th. $1,250,000 would report as $1,250.

Mark Eisinger

@Sylvia Cook If you want the amounts in thousands, you can adjust the Column formula. Use Actual/1000 instead of Actual. Make sure you indicate on your report “In Thousands” or “<000>”.

Sylvia Cook

@Mark Eisinger
Ahh… ok, that would work. I was hoping for a toggle because most times I do not want it rounded.

However, I found how I can do a custom format in Excel which is easy. I will just export to Excel when I need to apply the format.