Hi,
I've been building a dashboard which uses relatively simple, yet long winded formulas for calculating percentages and comparisons using past data.
I'm starting to have issues with understanding how everything works because the formulas are so long (up to 5-6 rows). What is the best practice for slicing up formulas into more manageable parts? I'd like to use variables but it seems I'd have to create a separate Klip just to store and manage them, is this correct? Then a new user input component for defining each variable? Or can I just somehow open up a list of variables inside the editor and assign them values there?
Regards,
Carlos