Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
8 months ago
Solved

List Generate Average as record;

  Hi, can someone explain what is happening here;   I have a standard accumulaton, with two outcomes  one for the sum and one for average ;  let alist = List.Numbers( 1, 20 ,1 ) in List.Genera...
Need Help
Show and Tell
  • PhilipTreacy's avatar
    PhilipTreacy
    8 months ago

    Dicken 

     

    I'm not sure what you are asking here.

     

    Clearly in the code z and y are always the same.

     

    But what is this?  It makes no sense.  Where are you getting this from?

     

     z / 2   <>    z = y/2

     

    You can't say a thing (z/2) is not equal (or equal) to another thing (z=y/2). 

     

    You can't have an assignment on one side of a logical test like this

     

    Again not sure how esle to explain this other than how I have.

     

     z / 2   <>    z = y/2 makes no sense mathematically and I don't know what you are trying to do there.

     

    Phil

     

Dicken's avatar
Dicken
Post Prodigy
8 months ago

i know it does not work the quesiton was why; 
if ;

each [x] < List.Count( alist) , 
each [ x = [x] + 1,  asum = [asum] + alist {x-1} , 
avg = [avg] + alist {x-1} ] )

here  asum and avg = same result and x = same result why 

avg = (  [avg] + alist {x-1} ) / x , 
avg2 = asum /x ] )

does avg not work and avg2 work, as  before divtins asum = avg ?



jgeddes's avatar
jgeddes
Super User
8 months ago

Maybe this table helps illustrate what is happening here. 

Avg1 is [avg] + alist{x-1}

Avg2 is ([avg] + alist{x-1)/x)

let
    Query2 = let alist = List.Numbers( 1, 20 ,1 ) 
in 
List.Generate( 
    ()=>   [ x = 1  , asum = alist {0} ,avg1 = alist {0}, avg2 = alist {0}] , 
    each [x] < List.Count( alist) , 
    each [ 
            x = [x] + 1, 
            previousAvg1 = [avg1],
            previousAvg2 = [avg2],
            asum = [asum] + alist {x-1}  , 
            avg1 = ( [avg1] + alist {x -1} ),
            avg2 = ( ([avg2] + alist{x-1})/x )
        ]
),
    #"Converted to Table" = Table.FromList(Query2, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"x", "previousAvg1", "previousAvg2", "asum", "avg1", "avg2"}, {"x", "previousAvg1", "previousAvg2", "asum", "avg1", "avg2"})
in
    #"Expanded Column1"