3 Replies Latest reply on Apr 1, 2020 2:47 AM by Dishant Shah

A LOD problem I can not fix - but it looks so easy? (now with Workbook :-))

Hey,

I'm struggling with an "easy LOD problem.

The goal is to show the total for each Team of "COUNTD([Amount])*AVG([Weight])" - so for Team A: 27+11+25+154+188,7 = 405,7

Note:

- Please consider "Amount" as a number of IDs which might occur multiple times, to count each id only once I have to use "CountD" instead of "SUM"

- I added "111" just for you into the picture, to understand the calculation is happening there

But by trying the following:

{FIXED [TEAMS] : ([ID*Weight])} I do not get the expected result - I see the SUM of all Amount values

Any idea would help, unfortunately I can not share any workbook due to confidence reasons.

• 1. Re: A LOD problem I can not fix - but it looks so easy?

Tobi Eckhardt wrote:

...

… unfortunately I can not share any workbook due to confidence reasons.

If I had a workbook, I would start off by breaking down nested LODs.

I would make this calc:

FIXED (whatever) : COUNTD([Amount])

And this calc:

FIXED (whatever) : AVG([Weight])

And then combine them into a third:

FIXED (whatever) : MAX( calc1 * calcc2 )

• 2. Re: A LOD problem I can not fix - but it looks so easy?

Hey Joe,

I followed your advice and came up with an anonyme workbook which still shows the issue, here a picture from it (in blue you see the number I would like to see for the dimension "Fixed Test")

here the workbook:

• 3. Re: A LOD problem I can not fix - but it looks so easy?

Use below calculated field and it will give you desired output.

{ FIXED [Team] : SUM(

{ FIXED [Team],[Category]:[ID*Weight]})}

You will get below result.

I am attaching workbook for your reference, let me know if you find any difficulties with this solution.

Thanks,

Dishant

1 of 1 people found this helpful