topic Formula Help in Water Cooler

Formula Help

Wed, 11 Apr 2012 06:43:02 GMT

Hi Everyone;

I created a line chart that includes average currency value based on years.

I am working with a lot of charts and tables. Therefore; I am facing with problems on the process of creating new formulas.

Most of them is based on "Date Field". So When I choosed any date from listbox, My currency line chart only gives data of specific date that I choosed. But I want to show currency trend while I want to show specific datas in other charts and tables.

Forexample; Please assume that, there are two objects, comperatively one of them is "Line Chart" that shows trend and another is "Table" only show specific data of selected date.

When I choosed from data list box anydate to see specific data of selected date, my another object (line chart) which I don't want it to be effected, is broken and shows only selected data.

I tried to fix formula by adding "1" at the begining the formula but I couldn't achieve. Also, from properties pop menus, I detached the object but when I open the file later I see object as a not detach.

My formula as follows ;

=if(Tarih <> GetFieldSelections(Tarih) or Ay<>GetFieldSelections(Ay) or Yil <> GetFieldSelections(Yil),AVG(KURGENEL_MRKSATIS),0).

Dimension of this formula is Year Field. Thus, I want to show trend currency based years.

In sum; I don't want this formula to be effected from any selection. How Can I success this ?

Thanks in advance,

Best Regards,

Mustafa Özyeşil

Formula Help

Jason_Michaelides — Wed, 11 Apr 2012 07:31:43 GMT

You need to remove the DateField selection from the average part of the expression:

=if(Tarih <> GetFieldSelections(Tarih) or Ay<>GetFieldSelections(Ay) or Yil <> GetFieldSelections(Yil),AVG({<DateField=>}KURGENEL_MRKSATIS),0).

Or you could exclude all other selections:

=if(Tarih <> GetFieldSelections(Tarih) or Ay<>GetFieldSelections(Ay) or Yil <> GetFieldSelections(Yil),AVG({1}KURGENEL_MRKSATIS),0).

Hope this helps,

Jason

Formula Help

Jason_Michaelides — Wed, 11 Apr 2012 07:34:13 GMT

Oh - hang on! I've just looke properly at the rest of your expression and it seems to be an attempt to achieve this! Remove all the IF statements too, to leave

=AVG({<DateField=>}KURGENEL_MRKSATIS)

=AVG({1}KURGENEL_

Jason

Formula Help

Wed, 11 Apr 2012 09:11:46 GMT

Hi Dear Jason;

Thanks for your interest and help.

Best Regards

Mustafa