BusinessObjects Board

Multiple Logic (code+reagion+Days)

building reports webintelligence
#1

Hi Expert,

i have one data

S.No. Code Reagion Days result

  1.                    abc                      North                    10           0

  2.                    abd                      North                    10           0

  3.                    abc                      North                      7            7

  4.                    xyz                      North                      7            0 

  5.                    xyz                      west                        5            5

  6.                    abc                     west                       10           0

  7.                    abc                      west                       4             4

now i need high light min day with code and reagion.

Please suggest which formula can be provide data menntion result column data.

Best Regards
Abdul Nisar

#2

You need a couple of variables:
1 - determine the min days in code/region:
v_MinDaysInCodeRegion = min( [Days] ) in( [Code] ; [Region] )

2 - compare the row to the min value
v_CompareDaysToMin = if [Days] = [v_MinDaysInCodeRegion] then 1 else 0

3 - create an alert/conditional format
= if [v_CompareDaysToMin] = 1 then yellow highlight

1 Like