1 2 Previous Next 20 Replies Latest reply on Feb 18, 2016 6:58 PM by Amanjot Klair

    ATTR Problem

    Ajeet ...

      Hi,

       

      I am connecting excel sheet with database with a common linking field. Excel contains a Field "TAT" containing Whole number only. WHen I use IF function on TAT, I am getting ATTR

      with the field automatically...

       

      The following is the Calc: ( the name of the excel file is : "Ajeet_Tableau TAT - 20160213"

       

      ====================================================================

      IF DAY([Ship First Outscan Time Dc]) > 0

      then

      ( IF ATTR([Ajeet_Tableau TAT - 20160213].[TAT])   >= [Date Diff for Att]  then 1 else 0  end )

      else 0

      END

      =========================================

       

       

      Instead I want the folllowing:

       

       

      IF DAY([Ship First Outscan Time Dc]) > 0

      then

      ( IF [TAT])   >= [Date Diff for Att]  then 1 else 0  end )

      else 0

      END

       

      ==================================

       

       

      tableauPNG.PNG

       

      Can anyone explain this pls ?

       

       

      Regards,

      Ajeet

        1 2 Previous Next