/// <summary>
/// Gets the totals row formula.
/// </summary>
/// <param name="tableName">Name of the table.</param>
/// <param name="columns">The columns.</param>
/// <returns></returns>
public string GetTotalsRowFormula(string tableName, List <ColumnData> columns)
{
if (SubTotalType == SubTotalType.Formula)
{
return(ConvertFormula(Name, TotalsFormula, tableName, columns));
}
else
{
return(string.Concat("IFERROR(SUBTOTAL(", SubTotalType.GetHashCode(), ",", tableName, "[", Name, "]),\"\")"));
}
}
