Subproduct with subtotal not working

Subproduct with subtotal not working

Posted by: claudiu on 10 November 2018, 7:25 am EST

• 

  claudiu

  • Post Options:
  • Link
    Copy

  Posted 10 November 2018, 7:25 am EST

  Hello,
  
  is this type of formula not supported:
  
  =SUMPRODUCT(SUBTOTAL(109,OFFSET(C4,ROW(C4:C21)-ROW(C4),0,1)),–(B4:B21=“USD”),–(A4:A21=“January”))

  Thank yousumproduct.zip

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 11 November 2018, 4:51 pm EST

  Hello,

  We are able to replicate the issue and hence we are escalating the same to the concerned team for the fix.

  Tracking id for issue is #267131

  We will update you as soon as we hear anything from our concerned team.

  Thanks,
  
  Reeva

• 

  rpatel

  • Post Options:
  • Link
    Copy

  Posted 14 March 2019, 12:46 am EST

  Hello,

  I am also encountering the same issue on our application. would you please let know it’s fixed or still it will take time to fix.

  For me, that’s formula working fine on an excel sheet but never able to see the same behavior in the browser.

  Regards,
  
  Ravish Patel

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 14 March 2019, 5:24 pm EST

  Hello,

  Our developers are already working on this issue and investigation is still under progress. We will update you once this issue will be fixed( hopefully soon).

  Thanks,
  
  Reeva

• 

  claudiu

  • Post Options:
  • Link
    Copy

  Posted 20 May 2019, 11:40 pm EST

  I’ve tested this in the latest version, although the formulas now work, even with just a couple of thousands rows the rendering of the document is extremely slow. Are the developers still working on it, as it stands now unfortunately we cannot use this feature in our production environments.

  Thanks!

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 21 May 2019, 8:25 pm EST

  Hi Claudiu,

  We are sorry but we are unable to replicate the issue at our end. Could you please share a small sample replicating the issue so that we could further investigate the issue?

  Regards