Skip to main content
Solved

Rounded Dollar Without Decimals in Inquiry

  • December 2, 2024
  • 7 replies
  • 105 views

rconandrewl
Freshman I
Forum|alt.badge.img

Hi, I’m trying to better format a Dashboard Table to show whole dollar rounding for some of our GI’s. I’ve been scouring different DACs and Community posts trying to find a ‘whole dollar’ schema that would provide a right aligned number with comma separators and no decimals. (#,##0).

I’m able to use these parameters for Report Design and Pivot Views, but cannot find a schema to use with this format. I’m hoping I’m just way overlooking the solution to this and maybe someone could help me out. I’d really like to avoid creating a Customization to achieve the formatting.

Best answer by clancour

@rconandrewl 

Found a dac and a field with PXDecimal(0)

APPaySelReport.SignBalance

Tested on a GI and it works… a number, right aligned, with commas, and no decimal.

View original
Did this topic help you find an answer to your question?

7 replies

darylbowman
Captain II
Forum|alt.badge.img+13

If nothing else, a virtual DAC with an unbound field specifying [PXDecimal(0)] should give you the schema that you need.


rconandrewl
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 19 replies
  • December 2, 2024
darylbowman wrote:

If nothing else, a virtual DAC with an unbound field specifying [PXDecimal(0)] should give you the schema that you need.

That’s my issue, I cannot find a Decimal(0) schema to use as a virtual DAC, unless I’m misunderstanding what you mean by ‘virtual DAC’.


darylbowman
Captain II
Forum|alt.badge.img+13

Yeah, I can't think of anywhere there'd be one. I was suggesting a simple customization. A 'virtual' DAC because it wouldn't be a real table, so no database changes.


Forum|alt.badge.img+1
  • Jr Varsity III
  • 75 replies
  • December 3, 2024

Hi ​@rconandrewl , Hope this help you to round off decimals - 

 


rconandrewl
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 19 replies
  • December 3, 2024
arthia98 wrote:

Hi ​@rconandrewl , Hope this help you to round off decimals - 

 

Thank you ​@arthia98 for trying, but unfortunately that does not help resolve my formatting goal. Using the Integer format removes the comma separators and left aligns the values making it very difficult to read dollar values varying in scale. I’m trying to replicate the number formatting I’m able utilize in Pivot Tables of #,### with no concern for rounding. 


Forum|alt.badge.img
  • Jr Varsity II
  • 63 replies
  • Answer
  • December 3, 2024

@rconandrewl 

Found a dac and a field with PXDecimal(0)

APPaySelReport.SignBalance

Tested on a GI and it works… a number, right aligned, with commas, and no decimal.


rconandrewl
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 19 replies
  • December 3, 2024
clancour wrote:

@rconandrewl 

Found a dac and a field with PXDecimal(0)

APPaySelReport.SignBalance

Tested on a GI and it works… a number, right aligned, with commas, and no decimal.

Thank you so much for helping me find this, I just tested in my GI and it worked!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings