Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you explain more what exactly you want to do?
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
can anyone sugeest any method to do so..
Regards,
Prajna
Expression:
=$(=Formula)
PFA
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.
Hi,
Try like this
=$(Only(Formula))
Note : Selection of Name is mandatory.
Hope this helps you.
Regards,
Jagan.
Hi,
Try this below expression, it works 100%
=$(=F1)
Thanku
Regards,
Prajna
Thanku All
Regards,
Prajna