# Perspective 8.1.26 Report Showing \ in some cells **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [May 5, 2023, 3:12pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329 "2023-05-05T15:12:09Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Jim\_Perks](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@Jim\_Perks](https://forum.inductiveautomation.com/u/Jim_Perks)\ **Post date:** [May 5, 2023, 3:12pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/1 "2023-05-05T15:12:09Z")
I am fairly new to Ignition and trying to create a report based on historical data. I create a tag historian data base ![Data 1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/9/99b10b3da7dd71f74ee73803a2234deddd918f1a.png) I then populate some cells ![data 2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/a/9aa0deaf963e0b0545d18fb7c46762f2bf84205b.png) However, on preview I see some values but some show N/A. On the right side of the screen I can see that they do have values, but I cannot figure why it shows N/A on the left? ![data 3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/3/439860e41cc907c66b76ee0fcf5b4adff51f5ca5.png) One thing I do notice is that the @@ on the values that work are right up next to the letters and the @@ on the values that show N/A are have the right @ spaced one space from the last letter. I did manually move it back next to the right most letter, but that did nothing. Any ideas? Thank you. ---
**Author:** ![Ryan\_Allen](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_allen/32/47013_2.png) [@Ryan\_Allen](https://forum.inductiveautomation.com/u/Ryan_Allen)\ **Post date:** [May 5, 2023, 5:26pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/2 "2023-05-05T17:26:20Z")
Can you show the properties tab for that cell? Wondering if there's a format issue ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 5, 2023, 5:29pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/3 "2023-05-05T17:29:38Z")
`N/A` is the default to show for nulls in datasets. If your data definitely isn't null, check your keys. ---
**Author:** ![Ryan\_Allen](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_allen/32/47013_2.png) [@Ryan\_Allen](https://forum.inductiveautomation.com/u/Ryan_Allen)\ **Post date:** [May 5, 2023, 5:29pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/4 "2023-05-05T17:29:52Z")
I'm also wondering if there's a space at the end of your data key alias for those that's causing issues ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [May 5, 2023, 5:30pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/5 "2023-05-05T17:30:05Z")
I wonder if it's the trailing spaces in the key names getting normalized somewhere in the process. ---
**Author:** ![Jim\_Perks](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@Jim\_Perks](https://forum.inductiveautomation.com/u/Jim_Perks)\ **Post date:** [May 5, 2023, 5:33pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/6 "2023-05-05T17:33:39Z")
![data 4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/3/c35d11e79aca9dc3c5e0e9676d5fab2d99a49999.png) These are the properties of the N/A cell ![data 5](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/e/2e01742957cf6fc5b7a40504e5cb09142b805f39.png) These are the properties of the good cell ---
**Author:** ![Jim\_Perks](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@Jim\_Perks](https://forum.inductiveautomation.com/u/Jim_Perks)\ **Post date:** [May 5, 2023, 5:36pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/7 "2023-05-05T17:36:00Z")
I use the same key - below is a pic. I believe you are asking about the Data Key. The table is using that one tag\_history key. If you are referring to another key please let me know. Thanks ![data 6](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/1/61f180381d71bea19492b10baea65f6a585b8f85.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [May 5, 2023, 5:39pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/8 "2023-05-05T17:39:32Z")
It's 100% the trailing spaces on the columns. Look at the XML document closely; the two values that _aren't_ working are the ones with trailing whitespace. Fix those two columns in your data source and then update the table cells accordingly and it should start working. ---
**Author:** ![Ryan\_Allen](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_allen/32/47013_2.png) [@Ryan\_Allen](https://forum.inductiveautomation.com/u/Ryan_Allen)\ **Post date:** [May 5, 2023, 5:43pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/9 "2023-05-05T17:43:22Z")
In your tag\_history query, remove any spaces at the end of the data key alias ---
**Author:** ![Jim\_Perks](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@Jim\_Perks](https://forum.inductiveautomation.com/u/Jim_Perks)\ **Post date:** [May 5, 2023, 5:53pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-26-report-showing-n-a-in-some-cells/73329/10 "2023-05-05T17:53:55Z")
I agree. Wow @ PGriffth and Ryan\_Allen. It was ONE space to the right in the Data Key Alias that was giving it the N/A. That one had me stumped all morning. Thankful for this forum 🙂 ![data 7](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/8/5860a6134a4d4be34522f64e8be778273c5c7f49.png) Now it all works ![data 8](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/2/c27522b7412352d0768eaec183ab739b1c1a22f0.png) Thank you al again!! Now I know 🙂