Expression Set Analysis

[andrea90casa]

Hi at all,

I have a dataset with one field called data and another one called unit price

I would like to create a formula that shows me the first available unit price for a specific product, i have created a variable called MinData with this formula =Min(data)

And then i wanted to try this one

Avg({<data = $(=MinData)>}Unit_Price)

But it doesn't work, anyone can help me with this..

Best regards

Andrea

[krishnacbe · Accepted solution]

MinData variable settings I have added expression as =Date(Min(data))

avg({<data={"$(MinData)"}>}Unit_Price)

Hope it works

[andrea90casa]

Thank you very much. It's works