topic Re: Null Values in Pivot table in App Development

Null Values in Pivot table

Samrithi — Thu, 20 Jun 2019 20:56:59 GMT

I have pivot table with calculated measures as attached.

but trying to remove the blank values and unchecked the null values also but still not working .

appreciate the solution.

Thanks

Re: Null Values in Pivot table

Vegar — Thu, 20 Jun 2019 22:09:13 GMT

The checkboxes you have unchecked is to exclude if the dimension values are null(), not the expression.

You have dimension values, but you do not have expression output on all these dimension value combination.

Try to, in properties, uncheck include zero values in the add-on -> data handeling section, it might help.

Re: Null Values in Pivot table

Samrithi — Thu, 20 Jun 2019 23:03:34 GMT

Yes . You are correct its not the actual null values, those are the values which are not filtered on calculated dimension.

I tried it its not working.

Actually added date variable in the expression but its not filtering the dates as shown(pic).

Actual format could be in new file it should filter for every Thursday values like 4/11, 4/25, …

Its working in my local version i.e new but my work version is feb2018 so its not working the same in old version.

expression is :

"if([BBK.WeekDay]='Thu',
num((rangesum(Before(sum({<[BBK.PERIOD]={">=$(=vStartDate)<=$(=vEndDate)"}>}[BBK.BBK_ITEM]),0,day([BBK.PERIOD])))/
rangesum(Before(sum({<[BBK.PERIOD]={">=$(=vStartDate)<=$(=vEndDate)"}>}[BBK.BBK_OPP_ITEM]),0,day([BBK.PERIOD])))),'#0.00%')

,0)"

Its working on new version but not in the old one. tried many ways like below.

1. >=$(=$(vStartDate))<=$(=$(vEndDate))

2.>=$(=date$(vStartDate))<=$(=date(vEndDate))

3. >=$(vStartDate)<=$(vEndDate)

still no use. taken variable on load script also but not working.

Appreciate the solution