Using Aggr + If and Set Analysis

agigliotti — Fri, 20 Mar 2015 10:40:11 GMT

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

Re: Using Aggr + If and Set Analysis

Anonymous — Tue, 07 Jul 2015 12:55:52 GMT

Did you solve this?

If so, how?

agigliotti — Tue, 07 Jul 2015 13:45:51 GMT

I solved separating the table with "LF tipo budget" from the cloud.