Forum Discussion

SIBI1998's avatar
SIBI1998
Helper I
4 years ago
Solved

AND and AND NOT Condition

Hi,             Here I have needed AND and AND NOT Condition for ;   I have 5 Stages (Stage1,Stages2,Stages3,Stages4,Stages5) and (Verified Ekyc) as one Column I have Needed Like with the Below S...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi SIBI1998 ,

     

    Please try:

    Column = 
IF (
    [Stage1] <> BLANK ()
        && [Stage2] <> BLANK ()
        && [Stage3] <> BLANK ()
        && [Stage4] <> BLANK ()
        && [Stage5] <> BLANK ()
        && [Stage1] <> "Rejected"
        && [Stage2] <> "Rejected"
        && [Stage3] <> "Rejected"
        && [Stage4] <> "Rejected"
        && [Verified Ekyc] <> BLANK (),
    1
)

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

SIBI1998's avatar
SIBI1998
Helper I
4 years ago

@Aditya_Meshram I have been Coming up with this error while applying the Formula.

 

 IF(ISBLANK([Payment]) && NOT(ISBLANK([Stage5])) && NOT(ISBLANK([Stage4])) && NOT(ISBLANK([Stage3])) && NOT(ISBLANK([Stage2])) && NOT(ISNULL([Stage1])) && ISBLANK([Verified Ekyc]), This is not valid and I have used ISBLANK instead of ISBLANK

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

The brackets are incorrect.
Add closing brackets in the places I marked with orange and remove the 6 closing brackets from the end.

    • SIBI1998's avatar
      SIBI1998
      Helper I
      4 years ago

      @Aditya_Meshram

       

      The Formula which I have Used,

       

      Payment Pending = IF(ISBLANK('TABLEAU_REPORT overview_ekyc'[payment] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage5] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage4] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage3] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage2] && NOT(ISBLANK('TABLEAU_REPORT overview_ekyc'[stage1] && ISBLANK('TABLEAU_REPORT overview_ekyc'[verified_ekyc]),1)