Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below expression in Bar chart and Straight table...in straight table when I sum the rows I get different numbers and in bar chart I get different numbers however when I do expression total in straight table they match.
How can I do the same sum in bar chart ?
(if(ABRBuildingCode = 'THOM-B5635',22,
IF(Capacity-((count(if(len([EM EmpName])=0,
IF([RoomTypeAssigned]='OFFICE',
UniqueAB2Key)))
+
count(if(len([EM EmpName])=0,
IF([RoomTypeAssigned]='WRKST',
UniqueAB2Key))))) = 0
or COUNT(distinct (UniqueAB2Key)) =0,
sum([AB1BuildingCpacity(Manual)]),
COUNT(distinct (UniqueAB2Key)))))
Can you share some screenshots to show the discrepancy?
Expression total for Space type Office
Sum of rows for space type office
How about Add Sum(Aggr()) around the expression?
=Sum(Aggr(
(if(ABRBuildingCode = 'THOM-B5635',22,
IF(Capacity-((count(if(len([EM EmpName])=0,
IF([RoomTypeAssigned]='OFFICE',
UniqueAB2Key)))
+
count(if(len([EM EmpName])=0,
IF([RoomTypeAssigned]='WRKST',
UniqueAB2Key))))) = 0
or COUNT(distinct (UniqueAB2Key)) =0,
sum([AB1BuildingCpacity(Manual)]),
COUNT(distinct (UniqueAB2Key))))),
Dimensions))
Sum(Aggr(
(if(ABRBuildingCode = 'THOM-B5635',22,
IF(Capacity-((count(if(len([EM EmpName])=0,
IF([RoomTypeAssigned]='OFFICE',
UniqueAB2Key)))
+
count(if(len([EM EmpName])=0,
IF([RoomTypeAssigned]='WRKST',
UniqueAB2Key))))) = 0
or COUNT(distinct (UniqueAB2Key)) =0,
sum([AB1BuildingCpacity(Manual)]),
COUNT(distinct (UniqueAB2Key))))),
ABRUsage))
I tried that..that didnt do any diff
Are you trying to show 65,229 in the bar chart?
Yeah.
stalwar1Why would I get different counts ?
I think the issue might be related to the distinct count and/or the if statements. I will have to play around to give the exact answer
Ok.Please let me know if you come up wit something.Thanks much.