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?

[Gabriel]

Hi,

Do you mind attaching sample file? Or expand on what you want to achieve

[sunny_talwar]

Would you be able to share some more information regarding what you are trying to achieve here...

Best,

Sunny

[jonathandienst]

Hi

Your requirement is still not that clear. If you want to upload sample data, I would reduce the size significantly. I suggest that you upload a qvw document showing what you have at the moment, and whet you need to achieve.

Jonathan

[Anonymous]

you can create derived dimension or calculated list box this will be getting calculated at object calculation time

but you can not physically store some field in your data on run time

[#6]

Hi Jonathan,

Attached a sample QVW,what I would like to see is the Sum changes based on the input box value.

[Anonymous]

and what exactly you want to enter in input box ?
i mean where you want use vInput in calculation ?

[sunny_talwar]

Is COMMON and UNCOMMON are the user inputs? Until we know what the user inputs and what exactly he needs to see once he inputs something, we won't be able to help much.

Best,

Sunny

[#9]

The user input will be a numeric value based on which the field Trigger is validated using the condition IF((G2-AVERAGEIFS(B2:B10,F2:F10,"Yes"))>Sheet2!A1,"YES","NO")

[Anonymous]

if(Trend-Avg({<Flag={'Yes'}>}Days)>vInput,'YES','NO')