Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two data inputs for a value range, which reduce data in a report.
The problem here is after I finish typing one of the input and before I start to type the second value, the report already starts running.
My question is I need to finish typing two values before the report starts to run. Is there a way to implement this?
Many thanks.
Hi,
Perhaps, you could just add =len(Variable1)>0 and len(Variable2)>0 as calculation condition in the Chart Properties under the General tab.
Please find the sample attached.
Hope it helps.
Regards,
-Khaled
Hi,
Perhaps, you could just add =len(Variable1)>0 and len(Variable2)>0 as calculation condition in the Chart Properties under the General tab.
Please find the sample attached.
Hope it helps.
Regards,
-Khaled
Thanks Khaled. It works.
I tried the same method before, it failed because I put $ ahead of variable.
After I removed $, it works now.