Display negative numbers as positive

[jelindbe]

I have a population chart. Men's values are displayed to the right and women's values to the left, with the following measures:

For men: num(sum({$<Kjønnskode={'1'},År={$(=$(vMidyear))}>} [Folkemengde_3112]),'#.##0;#.##0')  

For women: num(sum({$<Kjønnskode={'2'},År={$(=$(vMidyear))}>} [Folkemengde_3112])*-1,'#.##0;#.##0')

I want the chart to display negative values as positive and try to achieve this with the num funciton.

My problem is that the num function does not do what I want.  Something wrong with my use of the function? Any other solution?

[Channa]

try FABS

[anushree1]

Do not Multiply women values with -1 

Try : For women: num(sum({$<Kjønnskode={'2'},År={$(=$(vMidyear))}>} [Folkemengde_3112]),'#.##0;#.##0')

[jelindbe]

That did not work. The numbers ended as genuine positive values and the chart displayed the sum of men an women. What I want is a pure display mechanism.

[jelindbe]

No. Women's value must be multiplied by -1. If not, there will be no population pyramid.

[tresesco]

Number formatting should have worked. Could you please share your sample app to check?

[jelindbe]

Where do I upload?

[tresesco]

Click on reply; in the new editor-> left bottom corner you would find a clip symbol to click on and upload 

[jelindbe]

This took a while. I have now stripped down the app to include just the population pyramid. Any help would be welcome.

[tresesco]

It seems that you are not doing the number formatting at the right place. Use the num() around the expression that results in negative figures.