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.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

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: 54767

    I and nothing ODD about the config..
    0_1535460644512_41ec023b-f75c-46d4-935f-b73481987de2-image.png

    0_1535460804254_6d8a5981-c474-497b-986e-5647d956911b-image.png

    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