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:



      Thanks for your help