Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
What function allows add average over two variables.
I used:
Avg (VAR1 and VAR2).
It doesn't work properly.
Many thanks in advance!
Try
=rangeAvg($(VAR1),$(VAR2))
Unfortunately, it doesn't work
For me on my sample working, it works. Share a sample app. let us try.
Santhosh,
Sorry for the question. Can I use this function in expressions (after upoading data)? When I use it in expression aberage over two fields is not estimated at all.
yes, you can use it. check if your variables are getting some values before averaging it.
Yes, they get. I did it the same way as in your example. Average for separate fields are calculated, but average for two fields is not