
Re: Table with sum and percentage
David Štorek Sep 5, 2018 3:59 AM (in response to Joshua Russin)Hi,
could you share some data? I am wondering why are you using such complicated expression. Could you a little bit explain what does or should does your calculation?

Re: Table with sum and percentage
Joshua Russin Sep 5, 2018 4:45 PM (in response to David Štorek)Attached is a sample file with the same issue. Based on the data, the result for 9/3/2018  area1, should read " 5 errors / 16%", 9/4/2018  area1, should read "7 errors / 17%", and 9/5/2018  area1 should read "4 errors / 18%"
Again, I'm sure there's a lot easier way of doing this, i'm just stuck with this one.
This is my expression:
sum(errors)
&
' Errors / '
&
if(area = 'area1',
(
(Sum({$<area = {"area1"} >}errors))
+
(Sum({$<area = {"area2"} >}errors))
+
(Sum({$<area = {"area3"} >}errors))
+
(Sum({$<area = {"area4"} >}errors))
+
(Sum({$<area = {"area5"} >}errors))
)
,
IF(area = 'area2', Sum(errors),
if( area = 'area3', sum(errors),
if( area = 'area4', sum(errors),
if(area = 'area5', sum(errors)
)))))
&
'%'

AreaTesting.qvf 192.0 K

