How to hide expression depending on condition . ?

[suvechha_b]

Hi All ,

Please kindly assist me , how to implement condition on expression ,

say for eg ,

if a dealer Name (Renault Paarl ) is open for bank - 'Wesbank' and 'MFC','STANDARD BANK' , then it will show on the three bank values in Main DIC report , the ABSA , ARIVA and SA Taxi column will be hidden.

8352  Wesbank

8356  MFC

8347 STANDARD BANK

8321 ABSA

21667 ARIVA

16575 SA Taxi

sample model attached.

[sunny_talwar · Accepted solution]

Here you go... use this for color

if(PayOutReceived_Deal_Bank='Wesbank',(if(Alt([Wesbank DIC], 0) > Alt([MFC DIC], 0),if(Alt([Wesbank DIC], 0) > Alt([ABSA DIC], 0),if(Alt([Wesbank DIC], 0) > Alt([SBSA DIC], 0),if(Alt([Wesbank DIC], 0) > Alt([ARIVA DIC], 0),if(Alt([Wesbank DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

    if(PayOutReceived_Deal_Bank='MFC',(if(Alt([MFC DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([MFC DIC], 0) > Alt([ABSA DIC], 0),if(Alt([MFC DIC], 0) > Alt([SBSA DIC], 0),if(Alt([MFC DIC], 0) > Alt([ARIVA DIC], 0),if(Alt([MFC DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

      if(PayOutReceived_Deal_Bank='ABSA',(if(Alt([ABSA DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([ABSA DIC], 0) > Alt([MFC DIC], 0),if(Alt([ABSA DIC], 0) > Alt([SBSA DIC], 0),if(Alt([ABSA DIC], 0) > Alt([ARIVA DIC], 0),if(Alt([ABSA DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

          if(PayOutReceived_Deal_Bank='SBSA',(if(Alt([SBSA DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([SBSA DIC], 0) > Alt([MFC DIC], 0),if(Alt([SBSA DIC], 0) > Alt([ABSA DIC], 0),if(Alt([SBSA DIC], 0) > Alt([ARIVA DIC], 0),if(Alt([SBSA DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

            if(PayOutReceived_Deal_Bank='ARIVA',(if(Alt([ARIVA DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([ARIVA DIC], 0) > Alt([MFC DIC], 0),if(Alt([ARIVA DIC], 0) > Alt([ABSA DIC], 0),if(Alt([ARIVA DIC], 0) > Alt([SBSA DIC], 0),if(Alt([ARIVA DIC], 0) > Alt([SA Taxi DIC], 0),Green(),Red()),Red()),Red()),Red()),Red())),

              if(PayOutReceived_Deal_Bank='SA Taxi',(if(Alt([SA Taxi DIC], 0) > Alt([Wesbank DIC], 0),if(Alt([SA Taxi DIC], 0) > Alt([MFC DIC], 0),if(Alt([SA Taxi DIC], 0) > Alt([ABSA DIC], 0),if(Alt([SA Taxi DIC], 0) > Alt([SBSA DIC], 0),if(Alt([SA Taxi DIC], 0) > Alt([ARIVA DIC], 0),Green(),Red()),Red()),Red()),Red()),Red()))))))))

[suvechha_b]

Thank you very much Sunny ... Its working 100 % .... Much appreciated.

Please kindly can I request for the below issue.

Please kindly assist me on the below requirement .