avoiding negatives in Reports
i want to filter my reports with negative values which are present in my data targets.
like i want to just have the positive values where as negative values are to adjust as per the change, so i just want positive values.
can i do this by including a status field in the report say if negative 1 or if positive 2 then pick all the values which are 2 and display in the report.
if yes how to fill this status field. plz help.
any suggestion please.
you can use 'condition' in query level,
may no need to add flag in infocube.
take a look this
hope this helps.