Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to hide block in a break with some condetion

I have 3 columns, ANI Repeat calls, Start time of the call in a webi report. I have repeated calls from same ANI at different starts times. I need to show ANI's which are repeated in different start times for same day. Can you please help us get the Repeated Calls form same ANI at different start times.


Please find the attached screenshot, where i need to get the calls form ANI 5555555555 Repeated calls=3 and I need to show them only repeated ANI's (Repeated Calls >=2)

Report.JPG (34468 B)
replied

Hairsh,

Create a variable with the below formula and apply filter on that.

=[Repeated Calls]In([ANI])

This formula gives you the repeated calls for every ANI. For ANI 5555555555 the variable will give you the value 3.

Apply the filter on the variable >=2.

Or also you can do it using the below formula too

=[Repeated Calls]ForAll([DNIS];[LOB];[Call End Reason];[Call End Location];[StartTime])

Cheers

Sri Harsha

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question