Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
they are field values for the Codice Documento variable
HI
Try like this
=Sum ({<[Documento] = {'INT-BUONOCAR','INT-BUONOSCA'}>}[QTA 1 Documento])
if they are field values then this should work
=Sum({<[Codice Documento] = {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])
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])
Hi you get correct result.
however your field INT-BUONOSCA is not conneced with date.
may be need to check the model.
Regards
ASHFAQ