topic Re: How to get Calculation in Rows in App Development

How to get Calculation in Rows

khanashique — Tue, 03 Apr 2018 08:40:16 GMT

Hi Experts,

I need to calculate the following in rows (normally we do calculations in columns)

Jobs 140

Completed 120

Open 20

Efficiency 16.7 (Calculation (20/120)*100)

The above calculation i can get in columns, Need to calculate the same in ROWS.

Thanks,

MAK

jaumecf23 — Tue, 03 Apr 2018 09:22:43 GMT

Hi,

You can use the ValueList function.

1st. Create a Dimension like this :

=ValueList('Jobs','Completed,'Open','Efficiency')

and then an Expression like this :

if(ValueList('Jobs','Completed,'Open','Efficiency')='Jobs',

Sum(Jobs),

if('Jobs','Completed,'Open','Efficiency')='Completed',

Sum(CompletedJobs)....

khanashique — Wed, 04 Apr 2018 04:29:04 GMT

Hi,

Thanks for your reply....

But the purpose is not solved of getting the below calculation in dimension...

Efficiency 16.7 (Calculation (20/120)*100)

Thanks.

MAK

gerry_hdm — Wed, 04 Apr 2018 05:10:52 GMT

an example as Excel or Qlik file would make this easier

Gerold

khanashique — Thu, 05 Apr 2018 06:10:31 GMT

Hi Thanks for your reply,

Below is the sample data...

Efficiency 73 (Calculation (11/15)*100)

Thanks,

MAK.