Money Expression Formatting Issues

[Boberts227]

In my Qlik Sense pivot table, I have multiple data format types per measure row. For example, I have values that should appear as currency ($#.##) and others that should appear as percentages (#.##%). I am having difficulty formatting each of these values using the built-in Auto and Number formats under the measure attributes. 

Can someone provide context on the expression I could use on the following to make it display as currency? 

(SUM({$<Scenario_NORMALIZED={'Total Actual'},"Year"={'$(Current_Year)'},View_NORMALIZED={'MTD'},Period={'$(Current_Month)'},"Index"={'PR9'},"Finance Geography_NORMALIZED"={'$(VZ_Area)'}>}Value)/2),

[Kashyap_R]

hi

Try using Num() Function to format your values

Hope this helps

Thanks

[Anismohamed32]

Hi,

Do you want to change the formats of the values of a single column or for different columns.

For Currency kind of measure, if you need a standard currency sign and format to overall application, make the Data type of the measure as Money and set the exact format needed in the set function on the main section of the load editor.

Set MoneyFormat={'$#,##.#0','-$#,##.#0'};

By Qlik_KiD

[qlikerB96]

Hi,

The easiest way is to use the Num() function.

Num(SUM({$<Scenario_NORMALIZED={'Total Actual'},"Year"={'$(Current_Year)'},View_NORMALIZED={'MTD'},Period={'$(Current_Month)'},"Index"={'PR9'},"Finance Geography_NORMALIZED"={'$(VZ_Area)'}>}Value)/2, '$#.##')

Good luck,

B.

[Boberts227]

I've tried wrapping my expression in the MONEY and NUM syntax, with '$#,##0.00;-$#,##0.00', but am not yielding the desired results. 

What does the Measure Number Formatting need to be selected as? When I use Measure Expression, my value displays as NaN. I can adjust the Number Formatting to Money, but then I lose my percent formats (see attached).

Thanks.

[Kashyap_R]

Hi

Set the format as a measure expression 

Thanks