How to display datas conditionned by datas in another column?

[#1]

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

[jonathandienst]

Hi

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

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

HTH

Jonathan

[PrashantSangle]

Hi,

Please find attach document

regards,

[Anonymous]

use the below expression

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

Please find attachement

anant

[#5]

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:

[PrashantSangle]

Hi,

can you post sample data,

Regards,

[#7]

Hi,

Check the atatched app.

Regards

Kumar

[#8]

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

Thank you in advance
Regards,
Thibaud

[#9 · Accepted solution]

Hi,

Like this

Test:

Load * Inline [
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

[#10]

That works, thank you so much!