topic Re: How to display % In Grand Total Column using Dimensionality in App Development

How to display % In Grand Total Column using Dimensionality

joshibabu_are — Tue, 14 Feb 2017 15:22:24 GMT

Hi <

I have Organization ,Bucket,Month Year are Dimensions

Count(employee Number ) as Expression

i want to calculate Compliance % in Grand Total(Dimensionality()=0)

Jan 2016 i want to show (96/102)*100=94%

Please find the attached Data Set

Re: How to display % In Grand Total Column using Dimensionality

sunny_talwar — Tue, 14 Feb 2017 15:35:50 GMT

May be this:

If(Dimensionality() = 0, Count({<Bucket = {'On_Time'}>} [employee Number])/Count([employee Number]), Count([employee Number]))

Re: How to display % In Grand Total Column using Dimensionality

joshibabu_are — Wed, 15 Feb 2017 03:28:36 GMT

Hi Sunny,

Thanks for your Time

Iam using similar expression But iam Getting 98.97% instead of 94% for JAN2016

i want to show distinct count so i used distinct in expression

Please find the attached QVW.

Thanks,

Joshi

Re: How to display % In Grand Total Column using Dimensionality

sunny_talwar — Wed, 15 Feb 2017 10:17:26 GMT

In that case, try this:

if(dimensionality()=0,

Num(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)),'#,##0.00%')

,count(DISTINCT Employee_Number))

Re: How to display % In Grand Total Column using Dimensionality

joshibabu_are — Wed, 15 Feb 2017 11:11:00 GMT

Hi Sunny ,

its working when its grand Total area.

But i want the same Compliance % as A Calculated Dimension area.

How to achieve same

please find the QVW

Thanks,

Joshi

Re: How to display % In Grand Total Column using Dimensionality

sunny_talwar — Wed, 15 Feb 2017 12:04:24 GMT

Like this?

=Num(Aggr(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)), MonthBucket),'#,##0.00%')