I have an urgent requirement to deliver, need help on the below issue.
I have a report which need to create alerts based on the comparison between two measures.
Below is the detail about the requirement.
I have current month and Previous month in the webi report, here i need to apply the alerts on Previous month column in the report.
if Previous month value is more than 2% of current month then it is green.
If Previous month value between 2% and -2%(Minus 2 percent) then it is red.
How can we calculate -2% and 2% and how can we apply alerts.
I have used the following formula
for 2% i have tried 2/Current month *100
for -2% i have tried -2/Current month *100
But it is not working, please help me on this issue.