Forum Discussion

pcolson's avatar
pcolson
Cloud Apps
02-07-2022
Solved

Un-weighting an average value

Hello all, I have what I hope is a simple question.   We have a database that can be boiled down to the image below.  Each entry has a date (YYYYMM) and whatever the monthly member count is for t...
Data Models
  • pcolson's avatar
    pcolson
    02-08-2022

     

    avg([YYYYMM],avg([Average Members]))

     

    I figured it out this morning.  Breaking it by YYYYMM, then taking the average's average (which will always be the same across the same month).

pcolson's avatar
pcolson
Cloud Apps
02-08-2022

That still gave me the 150 answer, but see below, I figured it out this morning.

harikm007's avatar
harikm007
Data Warehouse
02-08-2022

pcolson ,

Its great that you got the solution!!

I was trying to find why the other formula giving wrong result. I created a table with data what you have mentioned in original post. This is the result I'm getting:

SUM([YYYYMM], MAX([Members]))/DUPCOUNT([YYYYMM]) //Result 100
avg([YYYYMM],avg([Average Members])) //Result 200

Were you looking for the result 200? or 100, as mentioned in the original post.

 

  • pcolson's avatar
    pcolson
    Cloud Apps
    02-08-2022

    Oh my gosh that's so embarrassing.  Yes I meant 200.  I have revised the original question.  Thank you so much for jumping in and helping out!