• 

  Isaac Oard

  • 2023년 08월 02일 14:52

  Hi Dale Karasek
  
  At this time, there is no way to create this without using a suffix. I will create and Idea ticket for you to potentially get this added.

  You will be able to track progress and all updates on that ticket. 

  0
• 

  Nicole Volek

  • 2026년 09월 04일 12:32

  Hi there - I am also interested in this functionality - could you please provide any updates as to whether this is being looked at?

   

  0
• 

  Isabel Messore

  • 2026년 09월 08일 12:50

  Hi Nicole Volek, 

   

  If you're using Accounting or Currency format:
  - Set Shown in → Billions
  - Set Unit Format → Long Upper (displays "Billion")
  - Ensure the Currency symbol is set to $
  - The $ symbol will appear via the currency setting, and "Billion" from the unit format — together giving you $1.5 Billion

   

  Option 2 — Use Suffix (as you mentioned)

  If the above combination doesn't produce exactly what you need, the Suffix field (e.g., entering  Billion) combined with a Prefix of $ gives full control over the display. Note: Prefix and Suffix are display only and do not affect the underlying numeric value.

   

  There is no single "Long Upper $-Billion" format available as a preset — the $ and Billion labels come from two separate settings (currency symbol + unit format). Using Suffix remains the most flexible workaround if the combined display doesn't render as expected. I'lll get you added to the ticket in the meantime!

  0

댓글을 남기려면 로그인하세요.