Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try FABS
Do not Multiply women values with -1
Try : For women: num(sum({$<Kjønnskode={'2'},År={$(=$(vMidyear))}>} [Folkemengde_3112]),'#.##0;#.##0')
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.
No. Women's value must be multiplied by -1. If not, there will be no population pyramid.
Click on reply; in the new editor-> left bottom corner you would find a clip symbol to click on and upload
This took a while. I have now stripped down the app to include just the population pyramid. Any help would be welcome.