Skip to Content
avatar image
Former Member

Weighted Average in Lumira

Simplifying my query with easy numbers. I want to plot the graph showing weighted average as shown in the image below in Lumira but aggregation allowed is only at a simple average level and not a weighted average. Moving average is also giving me simple average numbers.

Formula: Weighted Average = Sum(rate*qty)/Sum(qty)

Couldn't find this in the archive. I'm a new user so pardon my lack of understanding.

Regards,

Sandiep

average.png (10.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 19, 2017 at 10:10 AM

    Hi Tammy,

    I'm currently using Lumira version 1.31.1 and my data source is SAP Business Warehouse.

    Add comment
    10|10000 characters needed characters exceeded