if else.. issue

[karthikeyan1504]

Hi,

I have a requirement as briefed below,

Please refer the table below,

account id, description, amount

1, Salary, 100

2, Bonus, 20

from above table I need to build a chart to show the salary & Salary + Bonus trendline. If condition doesn't helps..

Salary = 100

Salary+Bonus = 100 + 20 = 120

Could anyone please help me on this?

Thanks & Regards,

Karthikeyan.

[Peter_Cammaert]

I guess you want something like:

Some set analysis is helpful. However, it should work with an IF() as well. Set Analysis performs better

Peter

[Peter_Cammaert]

BTW I was assuming that a real trend line could easily jump over missing data points. For example, 2011 has no salary data but the Trend line will interpolate between 2010 and 2012.

[jagan]

Hi,

Try like this

Dimesion: account id

Salary Expression: Sum({<description={'Salary'}>} amount)

Salary + Bonue Expression: Salary Expression: Sum({<description={'Salary', 'Bonus'}>} amount)