The formulas in Dashpivot are powerful, however, there are limitations. Understanding these can help the users better plan the templates and potential challenges, and navigate through alternative formulas to be used and still closely generate the desired output.
Formula limitations:
Templates using table cross-referencing will not be able to nest more than one level of parentheses. This means formulas nested with more than one level of parentheses are not supported at this time. For example:
=FUNCTION((FUNCTION2), (FUNCTION3(FUNCTION4)))
The current workaround for this is:
Using different table cells to break down the formula
Remove any unnecessary sets of parenthesis
Use the 'IFS' function - e.g.
=IFS(Something is True1, Value if True1, Something is True2, Value if True2, Something is True3, Value if True3)
Templates using table cross-referencing will also not be able to find exact matches with VLOOKUP and MATCH functions.