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!
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])
You can't use where within set analysis. However:
=Sum({<Documento = {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])
Should work.
{<Document = {'INT-BUONOCAR','INT-BUONOSCA'}>} this expression tells the sum function to only documents that have the name INT_BUONOCAR and INT-BUONOSCA
may be like this
Sum ({< [Documento]={'INT-BUONOCAR','INT-BUONOSCA'}>}[QTA 1 Documento])
Regards
ASHFAQ
=Sum({<[Codice Documento]= {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])
it doesn't work...it doesn't select those specific values...
any other suggestion?
Could you share your qvw? Not sure why it wouldnt work.
Hi you are using
Sum({<[Codice Documento]= {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])
use this intead
=Sum({<Documento = {'INT-BUONOCAR','INT-BUONOSCA'}>} [QTA 1 Documento])
or post a sample app.
Regards
ASHFAQ
Yes, make sure you are using the exact field names from your qvw or it will not work.
Try this
=Sum({<[Codice Documento]= {"INT-BUONOCAR","INT-BUONOSCA"}>} [QTA 1 Documento])
Thanks & Regards
Milind
Could you provide some more info about INT-BUONOCAR and INT-BUONOSCA?
Are these field values in your data model or are they variables you made in your document?
this is the original file...
and yes, the name was correct in the formula