Hello,
I want to change the sign of negative amounts coming from SAP.
here is the data in excel
![doespirito_4-1663150039184.png doespirito_4-1663150039184.png](https://community.qlik.com/t5/image/serverpage/image-id/89068i7A6E7409D000350E/image-dimensions/511x240?v=v2)
I have a dimension in my data model that allows me to change the sign of REEL. So I created a measure
réalisé = sum({<NC_ND0={"R111_TVT"}>}REEL)*if(NC_ND1='A_TVT',-1,1)
It works fine in this table where NC_ND1 appears.
My problem is that when I use this measure in a KPI, changing the sign doesn't work.
![doespirito_3-1663149438663.png doespirito_3-1663149438663.png](https://community.qlik.com/t5/image/serverpage/image-id/89066i36B711496287BC14/image-size/medium?v=v2&px=400)
for me the expected amount is 1575261.17
does anyone have an idea?
Thank You