0

Using a constant with formatting

Requirement: use a constant double value in the grouping dimension in an aggregated table or the grouping dimension in a listing table with currency formatting.

Attempt 1:  use a formula in the Grouping Dimension (either Listing or Aggregated table) with the formula 7000.0. This displays 7000.0 and only offers date/time formats in the selection.

Attempt 2: use a formula in the Measure area of an Aggregated Table with the formula 7000.0 and Dollar formatting. Aggregation methods Count and Distinct display $0.00. All other aggregation methods result in -- display.

Attempt 3: use a global variable in the formula repeating attempts 1 and 2 with the same display.

What else should I try?

Note: that this method works as a Measure in a Listing Table.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 1 mth agoLast active
  • 12Views
  • 1 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.