9 Replies Latest reply: Mar 25, 2014 4:51 AM by Thibaud Labayle Couhat

# How to display datas conditionned by datas in another column?

I am working with a file such as follows:

 Mnemonic Maturity_Two STD_Two Maturity_One STD_One FJWSH489 30Y 204269,469 5Y 206833,719 KMYUC667 5Y 274532,891 5Y 277955,472 PJMCM574 3Y 177099,96 1Y 177275,884 HKHGV576 30Y 47370,9541 5Y 47964,9703 MHYLG715 30Y 372818,911 5Y 377506,833

I want to display a chart summing STD_One and STD_Two if Maturity_One= Maturity_Two

Thanks a lot,
Thibaud

• ###### Re: How to display datas conditionned by datas in another column?

Hi

=Sum(If(Maturity_One = Maturity_Two, STD_One))

=Sum(If(Maturity_One = Maturity_Two, STD_Two))

HTH

Jonathan

• ###### Re: How to display datas conditionned by datas in another column?

Hi,

regards,

• ###### Re: How to display datas conditionned by datas in another column?

use the below expression

=if(Maturity_Two=Maturity_One,Sum(STD_One)+sum(STD_Two))

anant

• ###### Re: How to display datas conditionned by datas in another column?

The fact is they are NEVER equals in the same line, so if I use your solutions if displays: "no data".

Maturity_One and Maturity_Two are both buckets calculated using a barycentric projection.

Here are the two charts I want to be in one:

• ###### Re: How to display datas conditionned by datas in another column?

Hi,

can you post sample data,

Regards,

• ###### Re: How to display datas conditionned by datas in another column?

Hi,

Check the atatched app.

Regards

Kumar

• ###### Re: How to display datas conditionned by datas in another column?

Hi,
I'm a student and using a Personal Edition, could you please display your information in a form I can read?

Regards,
Thibaud

• ###### Re: Re: How to display datas conditionned by datas in another column?

Hi,

Like this

Test:

Mnemonic, Maturity_Two, STD_Two, Maturity_One, STD_One
FJWSH489, 30Y, 204269469, 5Y, 206833,719
KMYUC667, 5Y, 274532891, 5Y, 277955,472
PJMCM574, 3Y, 17709996, 1Y, 177275,884
HKHGV576, 30Y, 473709541, 5Y, 47964,9703
MHYLG715, 30Y, 372818911, 5Y, 377506,833
]
;

Test1:
Load Mnemonic,Maturity_Two AS Maturity,STD_Two as STD
Resident Test;

Load Mnemonic,Maturity_One AS Maturity,STD_One as STD
Resident Test;

Drop Table Test;

and this could be the chart

• ###### Re: Re: How to display datas conditionned by datas in another column?

That works, thank you so much!