Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table like below which consists of expressions as feild values.
I need those expressions in this table to get evaluted when i load them into a straight table.
Thank you
This document may be useful. A screnshot of the output (I added some data where needed).
In the future, please don't post example data as a screenshot. Nobody likes copying text from an image...
Best,
Peter
May be with a dollar sign expansion?
$(=Sheet_Name)
This will only work with a single Sheet_Name as possible value.
If you want to create a table with dimension ID and using the appropriate expression per ID, I believe you need a pick() or pick(match()) solution:
Pick( ID,
Sum(Value),
Count(Value),
Avg(Value)
)
You can build this expression upfront as variable in the script using the table with ID and expressions and CONCAT() function.
edit: removed typo
If you do this - you will keep the static strings as well:
If( Flag = 1 , $(=Sheet_Name) , Sheet_Name )
Or you could quote the simple text strings in your original table. Which IMHO is more consistent with your original expression-based set-up.
This document may be useful. A screnshot of the output (I added some data where needed).
In the future, please don't post example data as a screenshot. Nobody likes copying text from an image...
Best,
Peter
Actually and on second reading, this is just an illustration of Stefan's earlier explanation. Points should go to him.
Hi,
one example of Stefan's and Peter's solution in the front end only:
hope this helps
regards
Marco