Data in column displayed well in app but on the Excel file generated by Appshet

[alexandre-sac]

Hi

I have a table that has a "related to" column. The table has a virtual column "total" that sums values from a column in the "related to" table.

On screen, the Total values are correct (1st line 1, 2nd line 18).

however when I use a bot to create an Excel File, the file generated contains this 

{nu1ber1i1it0}{1eci1al1i1it0}
{nu1ber18i20it0}{18eci1al18i20it0}

instead of the totals. I am using the <<[Total]>> reference.

Does anybody know why?

thank you

[Steve]

---

@alexandre-sac wrote:

On screen, the Total values are correct (1st line 1, 2nd line 18).

---

On screen where? Please post a screenshot?

Please post a screenshot of the Excel results, too.

Please also post a screenshot of the entire App formula expression of the virtual column that sums the values.

[alexandre-sac · Accepted solution]

Hi Steve,

I am not sure what I did (basically delete the template file and created it again) and all works fine.

many thanks