How can we create a dynamic field in the frond end?

[#1]

How can we create a dynamic field which is calculated from the existing fields in the data and again it gets validated based on a user input?

[Anonymous]

see if attached application solves ur problem

[#3]

Thanks Bhagirath...it does resolve the first part of it,now how can I use the same field created by the If condition to derive Trigger1 & Added_Flag Fields?

As I am using the expression sum({<Added_Flag={'Common'}>}Amount) in a chart.

[Anonymous]

what condition you are looking for

if(Trend-Avg({}Days)>vInput,sum({}Amount)) ,'YES','NO')=YES

=if(Trend-Avg({<Flag={'Yes'}>}Days)>vInput,sum({<Added_Flag={'Common'}>}Amount))

as i have attached

and if you want this condition

f(Trend-Avg({}Days)>vInput,sum({}Amount)) ,'YES','NO')=NO

then change expression to this

=if(Trend-Avg({<Flag={'Yes'}>}Days)>vInput,,sum({<Added_Flag={'Common'}>}Amount))

[#5]

Hi Bhagirath,

Thanks for your help!!!

What exactly I need is,the following fields

Trigger1 and Test_Flag1 creates the field Added Flag

And all these should happen based on the input value.

As a result if we take the Sum({<Added_Flag={'Uncommmon'}>}Amount) will be changing based on the input value.

It more like creating the entire cloumn in the front end,instead of an if condition in the load script.

Let me know if you are getting my point

[Anonymous]

Hi John,

Please note that its not possible to create a field in the front end on runtime,

Creation of field and storing is on scripting/Data model level task.

"we will have to use the expression we used to derive that field at all the places where it is required "

Regrads.

Bhagirath

[#7]

As you mentioned in your earlier reply,will use the If condition to modify the expression.

Thanks Bhagirath!!!