Add total of straight table to another value

[anuradhaa]

Hi,

I have a straight table

Country     Count     Amount    month

ABC          52          104               01

ccc              21          21               01

eee          60               120               01

ABC           70           140              02

ccc             5                  5            02

here i calculate Amount as below

if count < 50 , amount = count else amount = count * 2

So i get the total of this table = 390

now i need to add this 390 to another variable say y,

please tell me how to do that

Thanks

[#2]

Hi,

Can u plz share the sample file.

[felipe_dutra]

=Sum(Count*If(Count<50, 1, 2))

Felipe

[#4]

=$(your variable)+Sum(Amount*if(count<50,1,2))

[SunilChauhan]

see the attached file

[anuradhaa]

This is my Table,

Month	COUNTRY	COUNT	Amount
Jun	-	7	2.11
May	A	15	0.00
Jun	E	65	19.57
Jun	C	77	23.19
May	B	83	0.00
Jul	E	93	28.29
Jul	A	94	0.00
Jun	A	189	0.00
Jul	B	204	0.00
Jun	B	490	0.00
May	D	1,399	421.31
Jul	D	6,638	2,019.01
Jun	D	23,797	6,548.73
		33,151	9,062.20

So i have use counts to calculate Amount. I know how to do it. But the problem is i want to get Total Amount (9,062.20) and add that value to some another value,

Thanks

[kamalqlik]

Hi Anuradha ,

Where you want to add this value in same chart or somewhere else.

Regards

Kamal

[anuradhaa]

Same Chart

[#9]

you cannot do that. Put a text box just below the chart, make it look like part of the  chart and use my expression.

[anuradhaa]

This is waht i have in my straight table expression for amount

=Sum(if(COUNTRY='B',0,(if(Date#(AEI_MonthYear,'MMM-YY') <= date#('Jun-14','MMM-YY'),

((if((Sum(COUNT)<=130),(Sum(COUNT)*.15),if((Sum(COUNT)>130 and  Sum(COUNT)<=220),((Sum(COUNT)-130)*.033)+130,((Sum(COUNT)-220)*.041)+204)))*19.6) ,

((if((Sum(COUNT)<=130),(Sum(COUNT)*.101),if((Sum(COUNT)>130 and  Sum(COUNT)<=220),((Sum(COUNT)-130)*.053)+131,((Sum(COUNT)-220)*.0415)+206.2)))*19.6)))))

and i use below as variable,

=SUM(Aggr(Sum(if(COUNTRY='B',0,(if(Date#(AEI_MonthYear,'MMM-YY') <= date#('Jun-14','MMM-YY'),

((if((Sum(COUNT)<=130),(Sum(COUNT)*.15),if((Sum(COUNT)>130 and  Sum(COUNT)<=220),((Sum(COUNT)-130)*.033)+130,((Sum(COUNT)-220)*.041)+204)))*19.6) ,

((if((Sum(COUNT)<=130),(Sum(COUNT)*.101),if((Sum(COUNT)>130 and  Sum(COUNT)<=220),((Sum(COUNT)-130)*.053)+131,((Sum(COUNT)-220)*.0415)+206.2)))*19.6))))),Month,COUNTRY))

But that variable doesn't return the value