11 Replies Latest reply: May 14, 2018 8:41 AM by Sunny Talwar RSS

    Fomula Help - Dates and Measure

    Thomas Williams

      Hi,

       

      I need to create a formula for a line chart please.

       

      I have 2 measures already in place that currently produce 2 separate lines within the chart

       

      Actual:

      Sum({<Period = {"2018*"}, [Country] = {'CAN'}, Lookup = {'Extension'}>} Val)

       

      Forecast:

      alt(sum({<Period={"2018*"},[Sheet1.Country]={'CAN'},[Sheet1.Dashboard Name]={'P and N'}>}[Sheet1.Forecast]),NULL())

       

      I want to apply logic within the FORECAST formula to say -

       

      IF DATE <TODAY THEN ACTUAL ELSE FORECAST


      Can someone please help me work this out?