I have created X-values to add formulas to my excel file. However, when I execute the definition a blank value is passed to the excel file and not the X-value. How do I correct this? I am unable to get any value to pass to my excel file using X-values.
Setting the data type to string solved the problem.
I reviewed the posting #2050 for passing formulas to excel. A much easier way is to set the range in excel as a table and pass formulas that reference the table names in the formula. Such as [=IF(AND([@LastUpdated]-[@DueDate]>30,[@LastUpdated]-[@DueDate]<=60),[@Balance],0)]