8 Replies Latest reply on Jul 6, 2018 2:39 PM by Deepak Rai

    Calculations

    syed abdul qayyum

      IF [PROPERTY_STATE] = 'CT' THEN 60

      ELSEIF [PROPERTY_STATE] = 'CO' THEN 35

      ELSEIF [PROPERTY_STATE] = 'MD' THEN 45

      ELSEIF [PROPERTY_STATE] = 'MS' THEN 45

      //If([Prop State]="MA" And Not(Match([Breach Letter Desc];"*150*"));90;

      //If([Prop State]="MA" And Match([Breach Letter Desc];"*150*");150;

      ELSEIF [PROPERTY_STATE] = 'NC' THEN 45

      ELSEIF [PROPERTY_STATE] = 'NJ' THEN 33

      ELSEIF [PROPERTY_STATE] = 'NY' THEN 90

      ELSEIF [PROPERTY_STATE] = 'NY' THEN 60

      ELSEIF [PROPERTY_STATE] = 'RI' THEN 35

      ELSEIF [PROPERTY_STATE] = 'OK' THEN 35

      ELSE 30 END

       

      Can I please get help in the calculation where I commented out the logic. This logic was used in business object report. what function should be used instead of Match in tableau