$ Sign Formatting

[Former Member]

Hi,

This was posted originally in the HANA Forum but was redirected here.

I am attempting to format an Amounts field with the $ sign in front of the number (i.e. $500.00)

The report is consumed through AOLAP without a semantic layer in between.

The only currency used is in Dollars - no conversion takes place.

I've tried in HANA to format the field as as 'Amount with Currency Code' and specify USD or $ but the data formats as 500.00 USD or 500.00 $

I've tried to create a new column to concatenate the $ and Amount Field but if I do that I have to specify it as an Attribute and then am unable to aggregate it.

Is there a way to Format this field in AOLAP?