Hi when i attempt to publish a specific dashboard via embed or data agent the publishing is successful but when I go to view dashboard I get DV008 error with the following details:
Syncfusion.XlsIO.Implementation.Exceptions.ParseException: IFS isn't custom function. at position 9. Formula: iferror(IFS(J2<AH2,"2",J2>AI2,"2")), Position: 12
at Syncfusion.XlsIO.Implementation.FormulaTokenizer.RaiseException(String msg, Exception ex)
at Syncfusion.XlsIO.Implementation.FormulaParser.CreateCustomFunction(Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments, Boolean registerFunction)
at Syncfusion.XlsIO.Implementation.FormulaParser.ParseFunction(Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.ParseFirstOperand(Priority priority, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions& options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.ParseExpression(Priority priority, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.ExtractOperands(ExcelParseFormulaOptions options, ParseParameters arguments, ExcelFunction functionId)
at Syncfusion.XlsIO.Implementation.FormulaParser.CreateFunction(ExcelFunction functionId, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.ParseFunction(Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.ParseFirstOperand(Priority priority, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions& options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.ParseExpression(Priority priority, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaParser.Parse(String formula, Dictionary`2 indexes, Int32 i, ExcelParseFormulaOptions options, ParseParameters arguments)
at Syncfusion.XlsIO.Implementation.FormulaUtil.ParseString(String strFormula, IWorksheet sheet, Dictionary`2 indexes, Int32 i, Dictionary`2 hashWorksheetNames, ExcelParseFormulaOptions options, Int32 iCellRow, Int32 iCellColumn)
at Syncfusion.XlsIO.Implementation.FormulaUtil.ParseSharedString(String strFormula, Int32 iFirstRow, Int32 iFirstColumn, IWorksheet sheet)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.SetSharedFormula(WorksheetImpl sheet, String strFormulaString, String strCellsRange, UInt32 uiSharedGroupIndex, Int32 iRow, Int32 iCol, Int32 iXFIndex, Boolean bCalculateOnOpen)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseFormula(XmlReader reader, IInternalWorksheet sheet, Int32 iRow, Int32 iCol, Int32 iXFIndex, CellType cellType)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseCell(XmlReader reader, IInternalWorksheet sheet, List`1 arrStyles, Int32 rowIndex, Int32 columnIndex, List`1 cellStyleIndex)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseRow(XmlReader reader, IInternalWorksheet sheet, List`1 arrStyles, String cellTag, Int32 generatedRowIndex)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseSheetData(XmlReader reader, IInternalWorksheet sheet, List`1 arrStyles, String cellTag)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseSheet(XmlReader reader, WorksheetImpl sheet, String strParentPath, MemoryStream& streamStart, MemoryStream& streamCF, List`1 arrStyles, Dictionary`2 dictItemsToRemove, Dictionary`2 dictUpdatedSSTIndexes)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.ParseWorksheetData(WorksheetImpl sheet, Dictionary`2 dictUpdateSSTIndexes, Boolean parseOnDemand)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.GetUsedRange(Boolean isUsedRange)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.get_UsedRange()
at Syncfusion.Dashboard.Base.DataExtracter.SQLiteExtracter.ExcelToSQLite(String path, SchemaInfo selectedSchema, String sqliteDBName, IWorkbook workbook, Boolean isLoadAllData, String destinationPath)
at Syncfusion.DashboardService.DashboardService.MoveToSqLite(String path, SchemaInfo selectedSchema, ConnectionProviderType connectionType, Char separator, ObservableCollection`1 jsonTableInfoCollection, String sqliteDbName)
at Syncfusion.DashboardService.DashboardService.<>c__DisplayClass341_13.<FillRelationalDataManager>b__23(SchemaInfo s)
at System.Collections.Generic.List`1.ForEach(Action`1 action)
at Syncfusion.DashboardService.DashboardService.FillRelationalDataManager(String key, Boolean cacheable, String modifiedConnectionStrings, String token, String itemId, String reportId, Boolean hasMultipleDashboard, DashboardParametersModel dashboardParameterSettings)
at Syncfusion.DashboardService.DashboardService.InitializeControls(DashboardServiceArguments arguments)
at SyncInvokeInitializeControls(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
