Forum Discussion

perezco's avatar
perezco
Icon for Advocate III rankAdvocate III
5 years ago
Solved

using fucntions IF, &&&(AND), Colum with data and Column without Data

Could someone help to find the problem,  I am trying to category data result from diferent columns that has data or not.  lookingto get:   HD_ACT HD_EXPD C_ACT C_EXPD result HD_ACT 1...
Need Help
Tips and Tricks
  • perezco's avatar
    perezco
    5 years ago

    I found the error. it has inside of the logic, no symtax issue.

  • Icey's avatar
    Icey
    5 years ago

    Hi perezco ,

     

    Glad to hear that you have solved the issue.

     

    And I find that, it is just caused by this:

     

     

    VAR ISData_C_ACT =
    NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) )  -----------Change to data[C_ACT_SKU_Number]


    VAR ISBlank_C_ACT =
    ISBLANK ( data[HD_ACT_SKU_Number] )    -----------Change to data[C_ACT_SKU_Number]


    VAR ISData_C_EXPD =
    NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) )  -----------Change to data[C_EXPD_SKU_Number]


    VAR ISBlank_C_EXPD =
    ISBLANK ( data[HD_EXPD_SKU_Number] ) -----------Change to data[C_EXPD_SKU_Number]

     

     

    Right?

     

     

    Best Regards,

    Icey

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

perezco , can you explain the logic behind the calculation. As if syntax seems fine, You can use switch

Order of condition is important

AAA =
VAR ISData_HD_ACT =
    NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_ACT =
    ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_HD_EXPD =
    NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_HD_EXPD =
    ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_ACT =
    NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_ACT =
    ISBLANK ( data[HD_ACT_SKU_Number] ) --true, no data
----------------------------------------------------------------------
VAR ISData_C_EXPD =
    NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) ) --true, exist data
VAR ISBlank_C_EXPD =
    ISBLANK ( data[HD_EXPD_SKU_Number] ) --true, no data
----------------------------------------------------------------------
RETURN
Switch ( true() ,
        ISData_HD_ACT && ISBlank_HD_EXPD
            && ISBlank_C_ACT
            && ISBlank_C_EXPD,
        "HD_ACT",
   ISData_HD_EXPD && ISBlank_HD_ACT
                && ISBlank_C_ACT
                && ISBlank_C_EXPD,
            "HD_EXPD",
     ISData_C_ACT && ISBlank_HD_ACT
                    && ISBlank_HD_EXPD
                    && ISBlank_C_EXPD,
                "C_ACT",
    ISData_C_EXPD && ISBlank_HD_ACT
                        && ISBlank_HD_EXPD
                        && ISBlank_C_ACT,
                    "C_EXPD",
    ISData_HD_ACT && ISData_HD_EXPD
                            && ISBlank_C_ACT
                            && ISBlank_C_EXPD,
                        "HD",
    ISData_C_ACT && ISData_C_EXPD
                                && ISBlank_HD_ACT
                                && ISBlank_HD_EXPD,
                            "C",
    ISData_HD_ACT && ISData_C_ACT
                                    && ISBlank_HD_EXPD
                                    && ISBlank_C_EXPD,
                                "Both ACT",
    ISData_HD_EXPD && ISData_C_EXPD
                                        && ISBlank_HD_ACT
                                        && ISBlank_C_ACT,
                                    "Both EXPD",
     "failure"
                              
    )

 

perezco's avatar
perezco
Icon for Advocate III rankAdvocate III
5 years ago

I found the error. it has inside of the logic, no symtax issue.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi perezco ,

     

    Glad to hear that you have solved the issue.

     

    And I find that, it is just caused by this:

     

     

    VAR ISData_C_ACT =
    NOT ( ISBLANK ( data[HD_ACT_SKU_Number] ) )  -----------Change to data[C_ACT_SKU_Number]


    VAR ISBlank_C_ACT =
    ISBLANK ( data[HD_ACT_SKU_Number] )    -----------Change to data[C_ACT_SKU_Number]


    VAR ISData_C_EXPD =
    NOT ( ISBLANK ( data[HD_EXPD_SKU_Number] ) )  -----------Change to data[C_EXPD_SKU_Number]


    VAR ISBlank_C_EXPD =
    ISBLANK ( data[HD_EXPD_SKU_Number] ) -----------Change to data[C_EXPD_SKU_Number]

     

     

    Right?

     

     

    Best Regards,

    Icey

     

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