Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If(FAMILY='C',sum(Total INCOME), sum(INCOME))
If(FAMILY='C',sum(Total <Year> INCOME), sum(INCOME))
If(FAMILY='C',sum(Total INCOME), sum(INCOME))
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
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
If(FAMILY='C',sum(Total <Year> INCOME), sum(INCOME))
Perfect.