Can we use If and sum statment in same expression

[Karim_Khan]

Hi Team,

      Can we use If and sum statment in same expression.I am trying to calculate the belwo expression into single statment but unable to achive the same.

Dimenssion:

=if([Entry Pages] <>'adsk:en:home' and [Entry Pages] <>'adsk:en_gb:404',[Entry Pages],Null())

Expression:

=sum(Visits)

If I will use only =sum(Visits) then it will give me the sum of value  along with Junk character.

But I don't want Junk character in my calculation so I used the belwo set analysis in dimenssion

=if([Entry Pages] <>'adsk:en:home' and [Entry Pages] <>'adsk:en_gb:404',[Entry Pages],Null())

But I want to handle the both set analysis calculation in single expression.

Regards,

KK

MRKachhiaIMP‌jagan‌gwassenaar‌Kush141087‌

[Anonymous · Accepted solution]

try this Expression

=sum({<([Entry Pages]-={'adsk:en:home','adsk:en_gb:404'}>}Visits)

[alexandros17]

The logig shoul be something like:

Sum(If(cond=true, MyField, 0))

[cspencer3]

you should just be able to do:

Sum(

     if([Entry Pages] <>'adsk:en:home' and [Entry Pages] <>'adsk:en_gb:404',[Entry Pages] )

)

Also, this is not set analysis. Just IF logic.

[jagan]

Hi,

Try like this

=Count({<[Entry Pages] -= {'adsk:en:home', 'adsk:en_gb:404'}>} Distinct Visits)

Hope this helps you.

Regards,

Jagan.

[Karim_Khan]

Tnx a lot

[Karim_Khan]

Tnx a lot