Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi ,
Yes , you can use a macro on click of button with inputbox message .
Regards
Yusuf
Tnx Yusuf,
I'm new with macro, can you Pls be more specific
Hi,
Check this attach file and if your requirement is not fulfil then let me know.
Regards,
Ashutosh
it doesnt help, i need that for each Kpi i will have a different variable
Hi,
clear one thing, Kpi mean KpiID ?
thanks
Ashutosh
Hi ,
Please find the attachment with the fix.
here no macro is required.
Regards
Yusuf
yes Kpi mean KpiID.
i need that the Filed F3 will be INPUTFIELD is it possible ?
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
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.