RangeAvg adding two different fields

[#1]

How do I take this expression and add ClientSideActivity.Days Booked as well. So I want the same equation only adding both fields. So I tried number 2, but this doesn't work. Can anyone assist me in the correct syntax for number 1 expression adding in the Client side? Thank you in advance.

1. if(Week <=today(),(rangeavg(above([ProviderSideActivity.Days Booked],0,13))))

2. if(Week <=today(),(rangeavg(above([ProviderSideActivity.Days Booked],0,13))))+

if(Week <=today(),(rangeavg(above([ClientSideActivity.Days Booked],0,13))))

(O)nePuttGirl

[#2]

Does your first expression work?

If so, you could try the second expression without the second if(Week <=today().

if(Week <=today(),

rangeavg(above([ProviderSideActivity.Days Booked],0,13))+rangeavg(above([ClientSideActivity.Days Booked],0,13))

)

[#3]

Yes, the first expression works. I tried your expression and I don't get a trend line. I get to maybe add them in the load script unless you have any other ideas?

Thank you for you response,

(O)nePuttGirl