2 Replies Latest reply: Jul 7, 2015 9:45 AM by Andrea Gigliotti RSS

    Using Aggr + If and Set Analysis

    Andrea Gigliotti



      I have the following expression in straight table:


      count( {< [LF tipo budget] = >} DISTINCT

      aggr( if(

      sum( {< _FATTURATOFlag = {"S"}, [LF tipo budget] =, _FATTURATO_YTD_APFlag = {"S"} >} [Importo netto riga] )>0,

      [%Codice cliente], null()),

      $(vDimGrpResoGroup), [%Codice cliente] ) )


      It works well, but I need the expression to be not affected from the selection on field named "LF tipo budget".


      Can anyone help me to achieve it ?


      Thanks in advance for your time.


      Best Regards