Consulting

Results 1 to 14 of 14

Thread: Sumproduct/Subtotal > issue

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Sumproduct/Subtotal > issue

    Hi there,

    I'm having a problem with the following formula

    "=SUMPRODUCT((Completed_Weekly[Days CCD > OCD]=">0")*(Completed_Weekly[REQUEST_TYPE]="NEW")*(SUBTOTAL(103,OFFSET(Completed_Weekly[REQUEST_TYPE],ROW(Completed_Weekly[REQUEST_TYPE])-MIN(ROW(Completed_Weekly[REQUEST_TYPE])),0))))"
    I have isolated the issue to the (Completed_Weekly[Days CCD > OCD]=">0") part of it but cant seem to get it to work.

    I have tried (Completed_Weekly[Days CCD > OCD]=">0") and (Completed_Weekly[Days CCD > OCD]>0) with no success

    any ideas?

    thanks

    Paddy
    Last edited by Aussiebear; 04-27-2023 at 12:27 PM. Reason: Added code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •