Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have the following data set, lot of order line with different date.
I would like to have the average of column 3, regardless the fact that there are several line.
Basically i would like to select January and February and get as AVERAGE , 3 (2+4/ 2 MONTH).
Which is the right formula to get this result?
Thank you!
Perhaps this?
Sum(Distinct Measure)/Count(MonthField)
no is not giving the right results
Please provide sample input and may be expected result also helpful. And which object you want to test?
Find attached
with the selection January and February i should get 1,5 as allocated Instrument average.
It showing section access, Will u remove that and reload() then share. Or provide credentials
i removed section access
Seems, You forget to reload. TRy to reload and share
basically i would like to have the AVERAGE of the MONTH AVERAGE
app reloaded
for jan and february the results should be 2
Sorry - I can't help until unless you shared with out access. may be share sample inline table and result set?