Skip to Content
0
Former Member
Apr 10, 2014 at 08:42 AM

Conditional formatting over block structure is not working properly

29 Views

Hello there,

This is on BPC 7.5 NW.

We have used block structure in one of our reports for Account dimension. i.e. we have used EVRNG function for MemberSet instead of any other expansion.

Again in this Block structure we have applied the below conditional formatting for some range.

The rule is:-

If the value (which is fetched using EVGET function in this range)

1. is less than 0.45 then apply Icon1

Else

apply

2.icon2 if values lies in between 0.5 and 1.5

3.icon3 if value lies between 1.5 and 2.5

4.icon 5 if value lies between 2.5 and 3.5

So when the report is expanded, the icons are getting displayed as above conditional formatting only if the number of rows (data range) is less than 1000. If the number of rows exceeds 1000 i.e. then it displays values only not the icons.

Can anyone please suggest what might have gone wrong here.

Thanks

Lakshmi