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

    Using Aggr + If and Set Analysis

    Andrea Gigliotti

      Hello,

       

      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

      Andrea