Using field value in table expression

[#1]

hello...

I have a formulas in my table.I want to use those in the expression of my chart..How can i use that..its is not considering it as exression rather its is considering as simple text.

eg:

Name               Formula

Total sales       sum(sales)

Avg sale           avg(sales)

Regards,

Prajna

[vijetas42]

Hi,

Can you explain more what exactly you want to do?

[#3]

hi,

Actually i am storing set of formulas that is entered by user, as mentioned above in a table.

Now when user select name that particular formula must be applied in the chart.

say if i select total sales..In chart expression sum(sales) must be applied.If user select name as average sale avg(sales) formula must be selected.

Regards,

Prajna

[#4]

can anyone sugeest any method to do so..

Regards,

Prajna

[tresesco · Accepted solution]

Expression:

=$(=Formula)

PFA

[vijetas42]

Hi,
As per my understanding ,you can load names as inline and in chart you can put both the expression and make them conditional as =GetFieldSelection (inline_Field_name)='Total Sales' likewise for Avg.

[jagan]

Hi,

Try like this

=$(Only(Formula))

Note : Selection of Name is mandatory.

Hope this helps you.

Regards,

Jagan.

[shambhub]

Hi,

Try this below expression, it works 100%

=$(=F1)

[#9]

Thanku

Regards,

Prajna

[#10]

Thanku All

Regards,

Prajna