Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I want to create a listbox containing different variables I made which you can select.
So I have 5 variables created (5 formulas) which I want to put in a listbox so that users can select 1 which is then put into a graph.
How can I put the 5 variables in 1 listbox? I can't make a group because it is nog cyclic or drill down, I want to display the five variables just in a row.
How someone can help me!
Kind regards,
Paul
Hi.
Everything works fine in both versions.
You use alternative state so the selection you've made in listbox with formulas does'nt affect the pivot.
And remove '=' sign in front of your stored expressions.
Hi I am not sure but try like this.. goto the properties of listbox
when u create list box for one field ,when u scroll down the fieldnames u will find a option expression for listbox,
then use the necesssary formulas and create ur own list box..
Hi.
Use inline sstatement in script to load your 5 formulas into one field. Then you could use this field in a listbox.
How can I make 5 formulas loaded into 1 field using an inline statement?
load * inline [
fieldname
value1
value2
value3
value4
value5
];
and then use fieldname for your listbox
regards,
MT
Hi,
Is not working, it doesn't take the formula, the formula format looks like this:
sum([Betrokken bij echtscheiding <18])/sum([Jongeren onder 18 jaar])*1000;
But after the second bracket (before the next sum) it stops the formula, if have tried to put " around it but that doesn't help either.
Any ideas?
Regards,
Paul
Two things: the quotes + dollar-sign expansion
Also with the quotes and the $ sign it doesn't work
Have you tried single quotes?
if you want to see the result have you tried to put a = at the beginning?