Pick field/column name from a variable and use it in calculations

[#1]

Can someone please let me know is it possible to pick column name from variable and use it in set analysis?

I have created a drop down and added 4 -5 column names and when user selects any column from dropdown it calculates on the basis of that something like

=Count(Distinct  {<{(year_col) = {$(year)}>} IDS)

Thanks a lot for support

[swuehl]

Might be possible if you use dollar sign expansion for that, something like

=Count(Distinct  {< $(year_col) = {$(year)}>} IDS)

where year_col needs to be your variable and must expand to a valid field name.

[#3]

not working i tired

[swuehl]

Could you post a small sample?

[#5]

sure how can i add a file here

[swuehl]

Use the advanced editor, there is an 'Attach file' option. Follow the link on the upper right corner in standard editor, or it should be the default editor when you edit an existing post.

[#7]

Please click on below link to download the file

https://app.box.com/s/0jirug441a1wmhvh4dqt

Thanks

[Clever_Anjos]

=Count(Distinct  {<{$(year_col) = {$(=year)}>} IDS)

[swuehl · Accepted solution]

Your application works in principle. You just need to quote the year field names in your script to get the data correctly loaded in. There was also a typo in your expression 'sales' instead 'Sales'.

[#10]

Many thanks fro your help I wll try it.