Hello,
I want to change the sign of negative amounts coming from SAP.
here is the data in excel
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.
for me the expected amount is 1575261.17
does anyone have an idea?
Thank You