Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a question,
Is there a way we can disregard all selections except one. For Example, I have an application which has many fields so in that I want one of my chart to show data disregarding of all selections except the selection on currency.
Is there any way we could achieve using set analysis.?
Thanks,
Leni Balakrishnan
hi
Why ddidnt you try to fire trigger , and make the condition like
if(getFiledSelections(<filedName>)='currency',1,0)
hi
yes you can
it should looks something like
sum({1<Currency=Currency>}Sales)
so the 1 signals to disregard all selections , and the currency=currency implies the currency values
Thank you
But this is something like I have an expression and the expression should return value disregarding of all selections in the application except on the currency field.
As my expression is something like amount*rate and the rate will be calculated based on the currency type selected.
So how it is possible to achieve using triggers??
See this blog post: Ignore all selections except some specific fields using Set Analysis
Hi try below
sum({1<Currency=p(Currency)>}Sales)
Regards
ASHFAQ
Hi try below
sum({1<Currency=p(Currency)>}Sales)
Regards
ASHFAQ
I tried but it is not working. Checked by selecting on different currency but still the value remains same
Hi,
Can you post your sample app.
Regards
ASHFAQ
Not working