Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon
I wonder what condition I enter in the "Enable calculation condition". What I want is that the graph is calculated only when the tab in which it is open.
Thank you very much to all
For this you don't need a condition because hidden objects or objects on other sheets won't be calculated. Useful are those calculation conditions especially to limit the amount of data which they have to calculate, for example by objects on a date-level to max. 30 dates instead of plotting many years with conditions like:
if(getselectedcount(date) <=30, true(), false())
- Marcus