Help including 1 more parameter

  • Hi all,
    I'm trying to include 1 more parameter into the below code, on top of "DCN SHA", I'm also trying to add "DCN HQT" into the code for the error check


    Would anyone please be able to assist?


    =IF(ISERROR(ROUND(GETPIVOTDATA(" Setl Amt ",$A$1," Setl Date",WORKDAY(TODAY(),0)," Ccy",
    LEFT(F1,3)),2)),0,ROUND(GETPIVOTDATA(" Setl Amt ",$A$1," Setl Date",WORKDAY(TODAY(),0)," Ccy",LEFT(F1,3)),2))
    =ROUND(-ROUND(SUMIFS(
    INDIRECT("'"&TEXT(WORKDAY(TODAY(),0),"DD MMM YY")&"'!"&"F:F"),
    INDIRECT("'"&TEXT(WORKDAY(TODAY(),0),"DD MMM YY")&"'!"&"D:D"),"DCN SHA",
    INDIRECT("'"&TEXT(WORKDAY(TODAY(),0),"DD MMM YY")&"'!"&"E:E"),
    LEFT(F1,3)),2)-ROUND(SUMIFS(INDIRECT("'"&TEXT(WORKDAY(TODAY(),0),"DD MMM YY")&"'!"&"G:G"),
    INDIRECT("'"&TEXT(WORKDAY(TODAY(),0),"DD MMM YY")&"'!"&"D:D"),"DCN SHA",
    INDIRECT("'"&TEXT(WORKDAY(TODAY(),0),"DD MMM YY")&"'!"&"E:E"),LEFT(F1,3)),2),2)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!