variables

[#1]

Is it possible that for any Kpi i will be given a different value for F3.

Ie I want each Kpi will be variable that I can choose a different value and it effect the chart Table like now but with variable

Pls see attachement

[#2]

Hi ,

Yes , you can use a macro on click of button with inputbox message .

Regards

Yusuf

[#3]

Tnx Yusuf,

I'm new with macro, can you Pls be more specific

[#4]

Hi,

Check this attach file and if your requirement is not fulfil then  let me know.

Regards,

Ashutosh

[#5]

it doesnt help, i need that for each Kpi i will have a different variable

[#6]

Hi,

     clear one thing,  Kpi mean KpiID ?

thanks

Ashutosh

[#7]

Hi ,

Please find the attachment with the fix.

here no macro is required.

Regards

Yusuf

[#8]

yes Kpi mean KpiID.

i need that the Filed F3 will be INPUTFIELD is it possible ?

[#9]

Hi,

    I don't think so you have to create variable for every KPI because its not good way to do also. You can do in this way also.

Check attach file and let me know.

Regards,

Ashutosh

[sivarajs · Accepted solution]

Yes you can create F3 as inputfield

Declare in script before the table.

Inputfield F3 ;

Note: In table box it will accept numbers as well text. But in chart you need to use inputsum(F3) to get the input functionality and it will accept only numbers. So you can give user a seperate table box to enter input and it will have effect on chart as well.