Where Clause in Set Analysis

[#1]

Hi everyone, is it possible to write something like that in a formula (set analysis)?

=Sum ([QTA 1 Documento]), where [Documento] in 'INT-BUONOCAR','INT-BUONOSCA'

please do not suggest me to use the where clause in Load, because I cannot do it...I need to find a way to use it in the set analysis...

Thanks to anyone, who will try to answer me!

[#2]

they are field values for the Codice Documento variable

[MayilVahanan]

HI

Try like this

=Sum ({<[Documento] = {'INT-BUONOCAR','INT-BUONOSCA'}>}[QTA 1 Documento])

[Anonymous]

if they are field values then this should work

=Sum({<[Codice Documento] = {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])

[#5 · Accepted solution]

If Codice Documento is a variable:

if([Codice Documento] = 'INT-BUONOCAR' or [Codice Documento] = 'INT-BUONOSCA', sum(QTA 1 Documento))

If Codice Documento is a field in your data model:

sum({<[Codice Document] = {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])

[ashfaq_haseeb]

Hi you get correct result.

however your field INT-BUONOSCA is not conneced with date.

may be need to check the model.

Regards

ASHFAQ