Convert if expression into set analysis expression

[#1]

Dear Experts,

Help required to convert into if Expression into Set analysis. Expression follows as....

=((SUM(if(COEP.BUDAT_PRW >=v_FyFirstDate AND COEP.BUDAT_PRW <=v_CUREENT_DATE,COEP.MENGE1_PRW))

       -
              SUM(IF(VERSN_PRW=vBudget_Version  AND ZDATE_PRW >= v_FyFirstDate AndZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_QTYPRW*MDCL_QTY_PRW))  
              )
              *
              if (IsNull((SUM(IF(VERSN_PRW=vBudget_Version  AND ZDATE_PRW >=v_FyFirstDate And ZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_VALPRW * MDCL_QTY_PRW )))
                           /(SUM(IF(VERSN_PRW=vBudget_Version  AND ZDATE_PRW >=v_FyFirstDate And ZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_QTYPRW*MDCL_QTY_PRW))
                           )),0,
                           (SUM(IF(VERSN_PRW=vBudget_Version  AND ZDATE_PRW >=v_FyFirstDate And ZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_VALPRW * MDCL_QTY_PRW )))
                           /(SUM(IF(VERSN_PRW=vBudget_Version  AND ZDATE_PRW >=v_FyFirstDate And ZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_QTYPRW*MDCL_QTY_PRW))
                           ))
              )
              /amt

[sasiparupudi1]

hi

please try the following 2 expressions(first 2 lines in your formula) in a texbox and see if they return you the correct values

sum({<COEP.BUDAT_PRW={">=$(=$(v_FyFirstDate)) <=$(=$(v_CUREENT_DATE))"}>}COEP.MENGE1_PRW)

sum({<VERSN_PRW={"$(=$(vBudget_Version))"},ZDATE_PRW={">=$(=$(v_FyFirstDate)) <=$(=$(v_CUREENT_DATE))"}>} (LIKELY_QTYPRW*MDCL_QTY_PRW))