expressions evaluation

[#1]

I want to do some strange things, namely:

i have some field, filled with variables names

For examle

Field:

-----------

Year

Month

Day

where Year, Month & Day are fields in other tables

In chart I wnat to hane an expression like  =sum($(Field)

I mean if  Filed=Year then expression should be sum(Year)

Is it possible to do this?

[sridhar240784]

If i understood your Question properly.Your expression should be like =sum($(=Field)

Check out the attached application.

Hope this helps you,

-Sridhar

[its_anandrjs]

Hi,

I think you need to write a code some thing like below for expression calculation

=If(Getfieldselections(Year),Sum(Value))

See sample file

HTH

Rgds

Anand

[#4]

If Year, Month and Day are in different tables, just refer to them with the same fieldname so they all will line up irrespective of Yr, Mth or Day.

[#5]

Here is what the script look like (modified what Anand had attached previously).

[its_anandrjs]

Hi,

In this type of requirements make a composite key which contains Year Month and Day values and use this key so in this case your problem solve with this you need to use this key as dimension.

HTH

Let me know tomorrow it is too late.

Rgds

Anand