Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to do something that is not working, although I'm not too sure it is even possible in the first place.
What I'm attempting to do is dynamically create a field in a set analysis, so that it will be a different field depending on the selected scenario. Example:
Let's assume I have a field named OrderDate with the values Request and Confirmed.
Then, I have another two fields named OrderDateRequest and OrderDateConfirmed.
In the set analysis I would like to do the following:
sum(<{OrderDate$(OrderDate)={'20/02/2018'}>}#Volume)
Is it possible, to dynamically name a field like this? So that when I select Request or Confirmed on OrderDate it be selecting a values from different fields.
Thank you.
Best Regards,
André Braga
Hello Olivier,
I did manage to solve it by creating 2 variables for this - $(OrderDate) which has as value the OrderDate field, and the second variable $(OrderBacklogDate) with the value ='OrderDate'&$(OrderDate).
By using $(OrderBacklogDate)={'20/02/2018'}, I have now the desirable outcome.
Your example didn't fully reflect my intent, partly because the value selections of the OrderDate field, do not reflect the name of the fields I wanted to portray. Nonetheless it really helped me expand my thought horizon and create new ideas on how to tackle the issue. Thank you!!
Best Regards,
André Braga
Hi,
you could add a variable like :
vField = if(GetFieldSelections(OrderDate)='Request','OrderDateRequest','OrderDateConfirmed')
then sum( {< $(v) = {xxxxxxxxx} volume)
regards
Hello Olivier,
I did manage to solve it by creating 2 variables for this - $(OrderDate) which has as value the OrderDate field, and the second variable $(OrderBacklogDate) with the value ='OrderDate'&$(OrderDate).
By using $(OrderBacklogDate)={'20/02/2018'}, I have now the desirable outcome.
Your example didn't fully reflect my intent, partly because the value selections of the OrderDate field, do not reflect the name of the fields I wanted to portray. Nonetheless it really helped me expand my thought horizon and create new ideas on how to tackle the issue. Thank you!!
Best Regards,
André Braga