Can anyone provide me with a basic list of expressions that would be useful for finance?
Is there an expression to sum? Clarity is making me type into a "constant" field which is blank. I would love to be able to select a column such as "Allocation" and somehow write an expression to sum the allocation.
Also, when I go into the powerfilter, it shows a dropdown for "left", but sometimes there aren't the same selections that show up on the previous screen for my filter. Is there a way to create an expression to select a column from the previous filter screen? It would be nice to have that column added in the powerfilter section so that it matches the filter section on the previous screen.
Thanks for the help!