EXPRESSION need

[sona_sa]

Hi Team,

I have a two field, Family and Income. Below is structure:

FAMILY    INCOME

A                  10

B                 20

C                 15
C is Father and A and B is child. Now I want the sum of income where C will have total value and rest of child is his own income. Output is below :

FAMILY            INCOME

C                         45

A                          10

B                          20

How I can make an expression for this.

Regards,

DK

[Frank_Hartmann · Accepted solution]

If(FAMILY='C',sum(Total INCOME), sum(INCOME))

[sona_sa]

Hi Frank,

Thanks for reply,

I accept it, But I stuck here I have data year wise. Where D value is representing for every Year same figure. When I am clicking on Year, That time It is representing correct figure.

I attached my xls. for your reference.

Thanks

[sona_sa]

Hi Frank,

Thanks for reply,

I accept it, But I stuck here I have data year wise. Where D value is representing for every Year same figure. When I am clicking on Year, That time It is representing correct figure.

I attached my xls. for your reference.

Thanks

[Frank_Hartmann · Accepted solution]

If(FAMILY='C',sum(Total <Year> INCOME), sum(INCOME))

[sona_sa]

Perfect.