Report amounts divided by 1000?

Sylvia Cook
Sylvia Cook
Kudos 5 Fifth Anniversary Name Dropper Participant
in Blackbaud Financial Edge NXT® General Discussions

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

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @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
    Sylvia Cook
    Kudos 5 Fifth Anniversary Name Dropper Participant

    @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
    Mark Eisinger
    Tenth Anniversary Kudos 1 Name Dropper Participant

    @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
    Sylvia Cook
    Kudos 5 Fifth Anniversary Name Dropper Participant

    @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.

Categories