Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, I need to use a return of field in set expression:
if(GetFieldSelections(Chiave) = 'fin',sum( {$<Chiave={$('usare1')}>} Costi ),0)
where usare1' is a field of the table...
How I can do it?
Any suggestions?
Thanks
maybe this:
=if(GetFieldSelections(Chiave) = 'fin',sum( {< Chiave = P(usare1) >} Costi ) ,0)
I hope this helps.
where are you using that expression?
Hi,
Can you elaborate a little.
What field are you selecting, and what you want to achieve.
If usare1 is a dimension, try the following in your set-expression:
Chiave= P(usare1)
usare1 is a dimension in another table. so when I select 'fin' in tbl 1, the sum should return to me the sum of all values in the tbl1 with Chiave of tbl1 = to usare1 of tbl 2.
in this case, I select fin, since usare1 in the tbl 2 is 1, the sum should return 93
if(GetFieldSelections(Chiave) = 'fin',sum( {$<Chiave=P(usare1)>} Costi ),0)..
I need maybe to use the dimension in the expression in a differnet way...
maybe this:
=if(GetFieldSelections(Chiave) = 'fin',sum( {< Chiave = P(usare1) >} Costi ) ,0)
I hope this helps.
Hi,
=if(GetFieldSelections(Chaive)='fin',sum({<Chaive=p(user1)>}Cost),0) seems to work fine.
when you select fin, it returns 93, otherwise 0.
However, in what type of chart you wish to apply this and what is the business case behind this?