X-value doesn't copy to excel file

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.

Hi David,

I guess this issue is related to wrong data type setting for the Excel field “Balance due”. Please check whether the FlowHeater data type is set to “String” for this field.

Did you receive warnings about? Usually you should receive warnings because wrong conversions!

In case this does not solve the issue please post your FlowHeater Definition file for more analytics.

Thanks Robert

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)]