Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
MinData variable settings I have added expression as =Date(Min(data))
avg({<data={"$(MinData)"}>}Unit_Price)
Hope it works
May be flower bracket missed as syntax of set expression
Avg({<data = {$(=MinData)}>}Unit_Price)
Hi Anil
I tried with curly brakets in that position but it hasn't worked too
Try below expression
Avg({<data = {"=$(=MinData)"}>}Unit_Price)
or
Avg({<data = {"=$(MinData)"}>}Unit_Price)
Try this
Avg({<data = {'$(MinData)}>}Unit_Price)'
with this solutions it calcs the average considering all the unite price and it doesn't give to me the only first one
Can you share some sample data to debug.
This one for example.
In the first text box i would like to see the first price, for example for the product A. So the correct value should be 1,1
Andrea
Check below expression
=aggr(avg(Unit_Price),Product)
With that expression the result is 1.188 so the mean of all that value, so it is not give to me the min data unit price (01/01/2017 = 1,1)