Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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()))))))))
hello
in your graph, in dimension tab, you can code an expression under the conditional check box
the column will be shown only if expression is true
I am not sure I am able to follow what you are aiming for... the six columns that you highlighed from Main DIC should hide? When should they hide? when you select RENAULT PAARL within Dealer.name?
Hi Sunny ,
We got 6 banks below
8352 Wesbank
8356 MFC
8347 STANDARD BANK
8321 ABSA
21667 ARIVA
16575 SA Taxi
The requirement is if for dealer 'Renault Paarl' only Wesbank and MFC are open , thus the Main DIC report should only show value for the two bank and the other bank should not be there is the Main DIC report .
Another dealer 'Allen New ' is open for only ABSA thus he will only see for ABSA all the other bank should not reflect on the Main chart.
Hope this explain my requirement.
But is this based on selection in RENAULT PAARL? Because Dealer.name has multiple options
RENAULT PAARL
Active Motors
Active Motors Eldoraigne
Will you be selecting one of those and then the columns should show up?
Yes correct . I will select RENAULT PAARL dealer and it will show Main DIC report for Wesbank and MFC
May be check attached
Hi Sunny ,
Your logic is working . But Please kindly assist me , how to change the color as well.
So , the color should be green when Finance House Bank is having the highest DIC Amount . See as the below screenshot.
The row should be green.
Please assist.
Thanks .
I don't see this row in the sample you attached earlier... also, I don't understand the logic for the color?
Ok... you can take the same sample .
The first three row should be green ,
Say for eg , the first row , the highest DIC lies in Wesbank and the finance bank is also Wesbank .