Multiple filters in single expression

[vikas_nandanwar]

Hi,

How to use multiple filters in single expression?

I need following expression

Sum(Qty)

Exclude

Year = 2017 and

PType = Sal

My below expression is not working

Sum({<Ptype={"Sal"}>,<[Year]={"2017"}>} Qty)

Please suggest

Thanks,

Vikas

[Anil_Babu_Samineni]

Exclude should be -=

Sum({<Ptype-={"Sal"}>,<[Year]-={2017}>} Qty)

[vikas_nandanwar]

Not Working

Sum({<Ptype-={"Sal"}>,<[TransactionDate.autoCalendar.Year]-={2017}>} Qty)

My expression

[Anil_Babu_Samineni · Accepted solution]

You are not suppose to do with 2 angular bracket like, Though try this?

Sum({<Ptype-={"Sal"},[TransactionDate.autoCalendar.Year]-={2017}>} Qty)

OR, If you want to do using OR operator do this

Sum({<Ptype-={"Sal"}>+<[TransactionDate.autoCalendar.Year]-={2017}>} Qty)

[vikas_nandanwar]

Thanks this worked

[Anil_Babu_Samineni]

Great, Please close this thread

[Théo123]

Bonjour,

SI <+> correspond à OR, à quoi correspond le ET ?

Cordialement

[theoat]

Bonjour,

<+> correspond à une union (OR), alors que <*> correspond à une intersection (ET).

Cordialement,
Théo ATRAGIE.