Former Member

# Minimum in calculated key figure

Hi All,

I am trying to use the minimum function in a calculated key figure for Net Contents (0NET_CONT).

In the cube we have:

Article Content Unit Net contents

2000 KG 10

2000 KG 5

2000 KG 1

In my Bex query, by article 2000, the Net Contents appears as 16. I want it to be the minimum of whats in the cube (in the above example I would want it to be 1)

In my calculated key figure, I am using MIN (Net Contents, Net Contents) as my formula. And in the extended properties, I have specified calculate Before Aggregation. In my query though, it still reports as 16 instead of 1.

Any suggestions?

Thanks

Charla

##### Add a comment
10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Nov 19, 2007 at 04:27 PM

Hi,

I think you have to select after the aggregation in this case because before aggregation calculates every single record and you have to calculate with several records.

I hope it helps.

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 19, 2007 at 04:31 PM

Charla,

Try out with exception aggregation.

##### Add a comment
10|10000 characters needed characters exceeded
• Posted on Nov 19, 2007 at 05:05 PM

Go to the properties of the key Fig <b>Net Contents</b>.

Set the <b>Calculate Result</b> as to minimum.

Hope this helps

##### Add a comment
10|10000 characters needed characters exceeded
• Posted on Nov 19, 2007 at 05:15 PM

Or else try the following.

First u need to create a calculated Key Fig globally. You can do this at the extreme left end of the query Designer. Just right click on the Calculated key Fig and say New Calculated Key Figure

Give the description of the Key Fig and in the formula section just put the the key fig . 'Net Contents' in you case

When u say ok it will open the properties of the key fig there u can see Enhance>> at the bottom. Click on that make the exception aggregation to miminum and refernce characteristic Article.

Save this calculated key fig. Now use this newly created Calc Key Fig in the query.

##### Add a comment
10|10000 characters needed characters exceeded
• Posted on Nov 20, 2007 at 03:25 AM

Hi Charla,

Is your issue solved or are u still facing the problem???

##### Add a comment
10|10000 characters needed characters exceeded