Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
Help required to convert into if Expression into Set analysis. Expression follows as....
-
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
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))