topic Re: row based calculation of measures in App Development

row based calculation of measures

johann_bauer — Thu, 11 May 2017 12:47:51 GMT

Hey Guys,

im facing following problem.

I have a table with 3 rows and 3 measures. The Dimension KPI has 2 characteristics (EXT/INT) which I can use as a Filter.

For the calculation of the measures, Im using Set analysis.

The Customer needs different calculations for the KPI´s.

For example EBIT and OE should be filtered on the characteristic (EXT/INT) but for the calculation of CR we need the total of this both characteristics, no matter if I select EXT or INT.

KPI	Measure1	Measure2	Measure3
EBIT	12
CR	13
OE	13

My first thought was to use an IF Statement, like this:

IF(KPI='CR',Sum({1<....>}Value),Sum({$<....>}Value))

But the KPI are never explicitly selected, so this is not working for me.

Can I solve this in the Chart or do I need the change my Script.

Johann

Re: row based calculation of measures

sunny_talwar — Thu, 11 May 2017 12:50:45 GMT

But the KPI are never explicitly selected, so this is not working for me.

What do you mean when you say KPI are never explicitly selected?

Re: row based calculation of measures

johann_bauer — Thu, 11 May 2017 13:16:46 GMT

I mean they are not selected in a filter pane. All KPI are shown in the table

Re: row based calculation of measures

sunny_talwar — Sun, 21 May 2017 11:41:50 GMT

I am still not sure what you are looking to get and what is the issue you are running into, but try this

If(Only({1} KPI) = 'CR', Sum({1<....>}Value),Sum({$<....>}Value))

Re: row based calculation of measures

johann_bauer — Mon, 22 May 2017 19:00:42 GMT

Hey Sunny,

thank you for your reply. I will try your soultions. If it wont work i will attach a qvf file with a more detailed description of my problem.

Johann

Re: row based calculation of measures

johann_bauer — Wed, 05 Jul 2017 12:40:30 GMT

Hey im still on this issue,

I will upload my qvf, so maybe this will make my problem clear more understandable.

Re: row based calculation of measures

sunny_talwar — Wed, 05 Jul 2017 12:46:18 GMT

Try this

Sum({<KPI = {'OE', 'Rev'}>}VALUE) + Sum({<KPI -= {'OE', 'Rev'}, Scope>}VALUE)

Re: row based calculation of measures

johann_bauer — Wed, 05 Jul 2017 14:27:13 GMT

Hi Sunny,

thank you for your help