Using nested if statement and set analysis in expression- Not able to get Expression total.

[Anonymous]

Hello All,

I'm using a 20 line nested if statement and set analysis with in it in an expression for Column A.

I'm using Expression total and not able to get total for Column A it shows  '-' .

I don't wana use Sum of rows as I need a      Column D =  Total (Column A)  / Total(Column C) .

Product Type	Sales ($)	Unique Logins	Purchasers	% of Purchasers	ARPU ($)	ARPPU ($)
a	$581,167.13	539156	24832	4.61%	$1.08	$23.40
b	$2,260,373.08	158113	108953	68.91%	$14.30	$20.75
C	$199,650.28	158113	12812	8.10%	$1.26	$15.58
d	$501,515.54	542610	28090	5.18%	$0.92	$17.85
e	$72,771.71	428464	5316	1.24%	$0.17	$13.69
Total	-	542610	180003	33.17%	$17.73	-

I need ARPPU($) value as 20.9 which would be Column D =  Total (Column A)  / Total(Column C) .

Any help would be appreciated.

[johnw]

OK, so you don't want sum of rows, and you don't want expression total.  What DO you want?

From the value you want in ARPPU ($), I guess you want 20.9 * 180003 = $3,762,062.70 in Sales ($)?  And where is that number supposed to come from?

[Anonymous]

Hi John,

Sum of rows works fine , I actually want  expression Total, when I set to Expresssion total its giving me blank total for column A.

Then I want to get that column A Expression total / Column C Expression  total  for ARPPU Total which is 20.9.

Hope you understand the scenario.

[Anonymous]

Hi John,

Sum of rows works fine , I actually want  expression Total, when I set to Expresssion total its giving me blank total for column A.

Then I want to get that column A Expression total / Column C Expression  total  for ARPPU Total which is 20.9.

Hope you understand the scenario.

[Anonymous]

Sum of rows works fine , I actually want expression Total, when I set to Expresssion total its giving me blank total for column A.

Then I want to get that column A Expression total / Column C Expression total for ARPPU Total which is 20.9.