Cycle group -Global Calculation

[#1]

Hi i have the following issue.

i wish to calculate the differrence between Listprice and Base Price articles.

every article has a Base price attached to it.

i.e 100090001 - 19 Euro BasePrice (per unit)

                     -  17,5 ListPrice (Netsales / Qty)

That is of course no problem , [ListPrice (Sek)] - [BaseListPrice (Sek)] / BaseListPrice.

However where it gets tricky is when you cycle through the fields in the table to Customer. IF you do not select an Article you get no calculation.

i wish to perform this calculation for Customer, Year and so Forth.

So what i am looking for is a calculation which can selects all articles and does the calculation. I have made an attempt below without luck.

(([Net Sales

(SEK)] * Qty) / ([BaselistPrice(SEK)] * Qty)),[Item number])

i have attached a sampledataset to help.

Best

Brad

[Gysbert_Wassenaar · Accepted solution]

You have to aggregate [BaseListPrice (Sek)]. You'll have to figure out what (BaseListprice * ExchangerateEUR) has to mean at the levels of the dimensions in your group. I have no idea what makes more sense, sum(BaseListprice * ExchangerateEUR) or avg(BaseListprice * ExchangerateEUR) or something else. You know your data so you'll have to decide what aggregation function is appropriate.