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.