Trouble with Sum for distinct dimension values

[Former Member]

Hi!

I have a problem which I'm having trouble solving. It's doable in webI but I haven't been able to recreate it in Lumira.

Info:

I have 1 dimension ID.

I have 1 measure VALUE.

I am trying to calculate weight which is Sum(VALUE)/Count(ID), but this can't be achieved this simply as one ID can occupy several rows.

So if I have a dataset like this:

     ID, VALUE

1. 1, 1
2. 1, 1
3. 1, 1
4. 2, 2
5. 2, 2
6. 3, 6

The WEIGHT for all of these should be calculated as: SUM(((1+1+1)/3) + ((2+2)/2) + (6/1))

The WEIGHT should therefore be 3.

How can I achieve this in Lumira?
In webi I use Count(RowIndex()) to divide the sum of VALUE with the amount of rows it's presented in via ID. But I can't seem to recreate this in Lumira at all.

Any advice is appreciated.

I am using a .UNX as my datasource and I'm using Lumira 1.29 (upgrading to 1.30 in a very near future).

[former_member183750 · Accepted solution]

I don't see how Lumira would be able to do this. Perhaps a good suggestion for the SAP Idea Place - see link under my signature.

- Ludek

Senior Support Engineer Product Support

Join us for Lumira Social Hour May 26, 2016

Follow us on Twitter (#SAPLumira)

Got Enhancement ideas? Use the SAP Idea Place