7 Replies Latest reply: Jun 30, 2014 10:40 AM by Vincent Ardiet RSS

    Remplacer un "if" par un set analysis

    romain romain

      Hi everyone,

       

      I’m trying to replace formula with « if » by set analysis

       

      I have for an entity some days and each days are flagged « 0 » or « 1 ». If one of selected days is “1”, I will consider all selected days as “1”

       

      Following formula with "IF" works :

      =if(sum(FLAG)= 0, Sum(CaNetTtc_N),0)

       

      Cela reviendrait a agréger une dimension dans le set analysis, ce qui ne fonctionne évidement pas :

      That would be an aggregated dimension in the set analysis, which clearly does not work:

      =sum({$<sum(FLAG)={0}>}CaNetTtc_N)

       

      Thanks for your help

       

      Romain