urgent expression?

[#1]

i have a  AMOUNT FIELD,  TYPE FIELD,

AMOUNT:

100

200

300

400

500

TYPE :

BIG

SMALL

HERE I WANT FIND OUT AMOUNT FOR  'BIG;      WHERE TYPE =BIG  THEN    SUM(AMOUNT)--  ONLY BIG REALTED values

like wise small related  sum(amount)

i want write expressions indidually.

[senpradip007]

Could you please more descriptive?

[jonathandienst]

Hi

You need some sort of association between the amount field and the type field. Or some rule which can be used to identify which amounts are big and which are small.

Jonathan

[#4]

when tupe is small then sum(amount)  -  small associated values sum(amount)

type is big then sum(amount)  -  long associated values sum(amount)

[its_anandrjs]

Hi,

Is this two fields  AMOUNT and TYPE are in same table then please provide some data or you can use SET analysis for this.

Regards

Anand

[ychaitanya]

Amount_Table:

Load Amount,

If(Amount>300 ,'BIG' ,'SMALL')) as Type

From

Mysample.xls;

Type_Table:

Load * INLINE [ TYPE

'BIG'

'SMALL'

];

Then Assocaitions will be formed in Data Model and if you plot list boxes for Amount and Type .. then you can find the Big and Small amounts.

Hope this helps.

Mark the threads as helpful or answered which will help the others.

Thanks

Chaitanya

[#7]

s  pls tell me set analysis expression for this

[anbu1984]

=sum({<type={'BIG'}>}amount)

[ychaitanya]

If( Type= 'BIG',Sum({$ <Type='BIG'>} Amount),Sum({$ <Type='SMALL'>} Amount))

[its_anandrjs · Accepted solution]

Hi,

This are very simple SET analysis

For Big

sum({< TYPE  = {'BIG'}>} amount)

with if condition

sum(If( TYPE = 'BIG' , amount ))

For Small

sum({< TYPE = {'SMALL'}>} amount)

With If condition

sum(If( TYPE = 'SMALL' , amount ))

Regards

Anand