SumIf lookup problem on strings

Posted by: curiosichi on 25 October 2022, 5:39 am EST

  • Posted 25 October 2022, 5:39 am EST - Updated 25 October 2022, 8:38 am EST


    Through that stackblitz, you will see an observed issue with sumifs calc in a flexgrid. The expected result should be 2 in each of the 3 similar formulas, but the second column is not calculating as expected. A copy of this formula example in Excel works as expected.

    Could you provide me with some insight?

  • Posted 26 October 2022, 8:57 pm EST


    This is a bug, which is now escalated to the dev team for further investigation with internal tracking id WJM-25175. We will update you as soon as we have an update from the dev team.


  • Posted 10 November 2022, 5:34 am EST

    Good day to you,

    Any chance we can receive an ETA on this fix? It is affecting our customers and our ability to provide them with an estimate time for a fix.

    Thank you.

  • Posted 10 November 2022, 3:32 pm EST


    Sorry but there aren’t any updates, the issue is still under investigation at the Dev team. We have asked the dev team for updates on this case. We will let you know, as soon as we have a response from the dev team.


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels