12 Replies Latest reply on Jun 1, 2016 2:48 AM by lenaic.ridinger

    Test boolean value in "if" function

    Pierre Oms

      Hi all,

      I'm working on tableau desktop and i'm block.

      I have to use different formula according to the result of a boolean value but tableau said that calcul is wrong :

      IF [Prorata temporis] = True

      THEN SUM([Quantité]) * sum([Durée (en mois)])*MEDIAN([Prix catalogue])

      ELSE SUM([Quantité]) * MEDIAN([Prix catalogue])

      END

       

      Prorata temporis is my boolean value.

       

      HELP ME PLEASE !!!

       

      Thank you