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.

[MK_QSL]

What is the Logic behind Small and Big Amount

i.e. Any amount less than equal to 100 is Small and Greater Than 100 is Big.. then use as below in your script

IF(AMOUNT <=100,'Small','Big') as AmountType

[#3]

syntax eror pls check once

[jagan]

Hi Manoj,

Check this expression

For Big:

SUM({<TYPE = {'BIG'} >}AMOUNT)

For Small:

SUM({<TYPE = {'SMALL'} >}AMOUNT)

Hope this helps you.

Regards,

jagan.

[anbu1984]

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

[mjm]

Hello Manoj,

if you have both Amount and Type listed as fields in your data source then the best way to achieve this would be through set analysis:

=Sum({$<Type={'Big'}>}Amount) - Sum of Amount where Type is Big

=Sum({$<Type={'Small'}>}Amount) - Sum of Amount where Type is Small

I have attached an example app to show you this.

Please mark this as completed and answered if this helps.