Hi All
I need to make the below expression display as +ve , now it display as -ve :-
(
(rangesum(above(
Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"},SOURCE_GL = {"TDSS"}
,[Reporting Code] = {
">=50010<=
50090"
}
, month = ,year=>}[Amount]/$(Columndim89))*-1,0,rowno())))
+
(rangesum(above(
Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"},SOURCE_GL = {"TDSS"}
,[Reporting Code] = {
">=20006<=
20061"
}
, month = ,year=>}[Amount]/$(Columndim89))*-1,0,rowno())))
)
/
(rangesum(above(
Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"},SOURCE_GL = {"TDSS"}
,[Reporting Code] = {
">=70010<=
70066"
}
, month = ,year=>}[Amount]/$(Columndim89))*-1,0,rowno())))
Paul
