# Relation not being found **URL:** \ **Category:** Ask for Help\ **Created:** [December 6, 2021, 8:28pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593 "2021-12-06T20:28:05Z")\ **Posts on this page:** 18\ **Page:** 2
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 14, 2021, 7:00pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/21 "2021-12-14T19:00:18Z")
Now that I have a few more users using the app, the all the tickers are found. However, the LCID (my 4th ticker) one still isn’t showing up on my screen. Seems like a problem specific to that symbol? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 14, 2021, 9:53pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/22 "2021-12-14T21:53:00Z")
Haven’t been able to get back to it for a few days, but I had tried a variety of things. I had changed the symbol from LCID to XXXX on 1, 2, 3, 4, 5 of the entries. Nothing seemed to work. I couldn’t really pinpoint that specific symbol being the issue. I don’t think I tried converting other symbols to LCID or XXXX…or deleting all of the LCID lines and converting other lines to LCID. Unless one row is just corrupted in some way. Just really weird. ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 16, 2021, 4:05pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/23 "2021-12-16T16:05:06Z")
Think I should report this as a bug? If so, what would be the proper way to describe this issue? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 16, 2021, 4:20pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/24 "2021-12-16T16:20:15Z")
I just made a copy of your app, and I think I found the problem. Just give me a little while to confirm. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 16, 2021, 4:26pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/25 "2021-12-16T16:26:07Z")
[https://media1.giphy.com/media/oACFYaf7KE1eo/giphy.gif?cid=790b7611c8284b14df1475c3c5034bf73347b831ba03bc6a&rid=giphy.gif&ct=g(image larger than 4 MB)](https://media1.giphy.com/media/oACFYaf7KE1eo/giphy.gif?cid=790b7611c8284b14df1475c3c5034bf73347b831ba03bc6a&rid=giphy.gif&ct=g) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 16, 2021, 4:26pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/26 "2021-12-16T16:26:33Z")
Yes, confirmed. You were being bitten by floating point arithmetic. The problem was with your `rup/Total Profit` column… ![Screen Shot 2021-12-17 at 12.23.15 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/5/95aa6f59bab486e3768832d82fa21937edee037e.png) The fix is to run that through a math column to round the value to 2 decimal places… ![Screen Shot 2021-12-17 at 12.23.31 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a0a3f56e182a33e80588a1ff1a36a494af1b9560.png) … and then use that math column everywhere you were using the rollup column (Find All Uses makes that easy) Result: ![Screen Shot 2021-12-17 at 12.22.46 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c7d21a76e60ae50e7c2c991538132ade76dcb0fc.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 16, 2021, 4:28pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/27 "2021-12-16T16:28:59Z")
Geez, I had suspected that, and I was trying to force the unformatted numbers to show. Guess I did it wrong or looked in the wrong places. Nice find! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 16, 2021, 4:30pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/28 "2021-12-16T16:30:36Z")
hehe, as soon as I saw that he was building relations on numeric values, that triggered the spidey-sense. So it was just a matter of doing a bit of back-tracking 🙂 ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 16, 2021, 4:33pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/29 "2021-12-16T16:33:31Z")
🤯 wow! Thank you so much! I’ll start implementing this change. ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 16, 2021, 4:34pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/30 "2021-12-16T16:34:00Z")
Thank you as well for all the time you’ve spent searching through the app. I appreciate it! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 16, 2021, 4:41pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/31 "2021-12-16T16:41:10Z")
To be fair… > [@Jeff\_Hager](#): > > That aside, is there any chance that the value in your ‘Value’ column or the value in your ‘Total Profit’ column has has an underlying unformatted number with decimals beyond 2 decimal places? You were right all along 🙂 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 16, 2021, 5:17pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/32 "2021-12-16T17:17:46Z")
You’re still the one that found it. 😉 ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 17, 2021, 4:51pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/33 "2021-12-17T16:51:30Z")
So using this method works perfectly if, and it’s a small but significant if, the trade totals are unique. In most cases they are. However I did notice that if two ticker symbols have the exact same profit total for the month, one of them is eliminated during the unique element array plugin. Should I be setting this up differently? Thanks! ![Capture2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad5fd8cd5044f048f1baaa99850bc3153079cd45.png) ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 17, 2021, 7:55pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/34 "2021-12-17T19:55:24Z")
Or maybe I don’t need a unique filter at all? ---
**Author:** ![Trading\_5\_Talents](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trading_5_talents/32/33858_2.png) [@Trading\_5\_Talents](https://community.glideapps.com/u/Trading_5_Talents)\ **Post date:** [December 17, 2021, 8:09pm UTC](https://community.glideapps.com/t/relation-not-being-found/35593/35 "2021-12-17T20:09:26Z")
Hmm. So if I don’t find unique values, since the lookup profits are the same values, only the first ticker symbol displays, not both tickers… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2021, 1:56am UTC](https://community.glideapps.com/t/relation-not-being-found/35593/36 "2021-12-18T01:56:46Z")
> [@Trading\_5\_Talents](#): > > However I did notice that if two ticker symbols have the exact same profit total for the month, one of them is eliminated during the unique element array plugin. > > Should I be setting this up differently? Thanks! I didn’t really pay much attention to the methodology, I was just focused on identifying the “bug”. I’ll find some time today to take a look, and will let you know if I can see a better approach. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 18, 2021, 3:36am UTC](https://community.glideapps.com/t/relation-not-being-found/35593/37 "2021-12-18T03:36:43Z")
One thing regarding the fix I gave you the other day. Having a closer look at this now, I can see that the Math column that I suggested isn’t necessary. It’s better to apply the rounding when the profit is first calculated - in your Trades-\>Profit column. So if you adjust the formula in that column as follows: `Round(((Sell Price - Buy Price)*Quantity)-Fees,2)` Then the later math column isn’t required. ![Screen Shot 2021-12-18 at 11.31.20 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c13a9458eb09966a389eb34ec97b995e4c164bbf.png) ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 19, 2021, 3:37am UTC](https://community.glideapps.com/t/relation-not-being-found/35593/38 "2021-12-19T03:37:17Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed. [Previous page](https://community.glideapps.com/t/relation-not-being-found/35593.md?page=1)