7 Replies Latest reply: Sep 9, 2015 7:26 PM by arjun rao RSS

    YTD expression with if condition

      Hello All,

       

      I am trying to develop a chart for all available activities.

      The chart has to display YTD data. The required formula for expression is : (Total Cost of Activity) / (Exchange Rate).

       

      So, The YTD formula is:

      (sum({<YEAR={$(vMaxYear)},Start_Date={"<=$(vMaxDate)"},Month1=,Type=>}TotalCostofActivity))

      / (Avg({<YEAR={$(vMaxYear)},Start_Date={"<=$(vMaxDate)"},Month1=>}EXCHANGE_RATE)

       

      I have a situation where, some values of Total cost of Activity are null and some values of Exchange rate are null.

      The chart displays wrong total amounts.

       

      Can you all Please help me to develop dual if condition for the above mentioned YTD formula such that, zero value is displayed if either total cost of activity or exchange rate is null.