-
Re: Straight table calculated total row
Shiva Nagesh Bodepudi Jun 14, 2017 5:07 AM (in response to Tom Neal)Neal, didn't this work [Standard]/[Target]??
-
Re: Straight table calculated total row
Anil Babu Jun 14, 2017 5:13 AM (in response to Shiva Nagesh Bodepudi)Should be this for Yield Target
Sum(TOTAL [Standard]) / Sum(TOTAL [Target])
-
Re: Straight table calculated total row
Tom Neal Jun 14, 2017 5:16 AM (in response to Shiva Nagesh Bodepudi)Unfortunately not, unless I've overlooked something the result I got for Standard/Target is 313% as the Total.
That calculation works for the row values but not the total. The result I should get in the total is 102.7%
-
-
-
Re: Straight table calculated total row
Anil Babu Jun 14, 2017 5:37 AM (in response to Tom Neal)Is there any dimensions in your report, Would you able to provide qvw for testing
-
Re: Straight table calculated total row
Tom Neal Jun 14, 2017 6:11 AM (in response to Anil Babu )Yes here is a test qvw.
-
Straight Table Test.qvw 155.2 K
-
Re: Straight table calculated total row
Anil Babu Jun 14, 2017 7:24 AM (in response to Tom Neal)I am not using server now, May be stalwar1 cal help you
-
Re: Straight table calculated total row
Sunny Talwar Jun 14, 2017 7:29 AM (in response to Anil Babu )kush141087 response should work here
//Yield_Target
SUM(DISTINCT [Target Content])/
Sum(Aggr((SUM([Target Content])/SUM(Yield_Target)), Resource, Date))
-
-
-
-
Re: Straight table calculated total row
Shiva Nagesh Bodepudi Jun 14, 2017 5:40 AM (in response to Tom Neal)Use the columns in the straight table. You can reference earlier columns in the table,
-
Re: Straight table calculated total row
Tom Neal Jun 14, 2017 5:47 AM (in response to Shiva Nagesh Bodepudi)How can I reference expression columns in a straight table?
-
-
-
-
Re: Straight table calculated total row
kushal chawda Jun 14, 2017 7:07 AM (in response to Tom Neal)try this expression
SUM(DISTINCT [Target Content])/
(sum(aggr(sum([Target Content])/sum(Yield_Target),Resource,Date)))
-
Re: Straight table calculated total row
Tom Neal Jun 14, 2017 7:32 AM (in response to kushal chawda )Worked perfectly...Thanks!
-
-
-
-
-
-
-