Skip to Content
Former Member
May 12, 2016 at 07:24 PM

Writing formulas in alerts based on the comparison on Percent growth of values


Hi Gurus,

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.