Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Excel report generating incongruent values
-
I have successfully created an excel report however one device (VELO409) is reporting 7 X larger sum than is shown in the point detail window... I cannot find any reason for this one point to be incorrect. I have removed and recreated the point and the associated named range with no change.
Start: 2018/05/31 18:32
End: 2018/08/28 10:18
Minimum: 0 kW路hrs @ May 31 18:32
Maximum: 0.07 kW路hrs @ Jul 27 04:41
Average: 0.01 kW路hrs
Integral: 109084.5 s
Sum: 847.7 kW路hrs
Log entries: 54767I and nothing ODD about the config..
It should be reporting 848 but reports 6605.. Any ideas how to find the issue or where to look? I have poured through the excel input file and cannot find any discrepancies or mistakes with the named ranges, everything looks correct.
-
I believe the error must be in the input file because I removed 409 completely and 409 values still got populated.. I will recreate the input file next.
I removed the range and recreated it and now get and error when running
"Cannot get a NUMERIC value from a STRING formula cell"
Don't know where this is coming from because all the cells are formatted as numeric
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 馃挆
Register Login