3 Replies Latest reply: Mar 22, 2017 3:56 AM by Sunny Talwar RSS

    Picking specific data for the given year

    Summi Zafar

      Hi, I am trying to load a data from a table which has few columns with one column as a year. When i use the following function it works

      Sum({$<ValidForYear={$(=Year(Today())-1)}>}NetMaximumCapacity)

       

      but when I use  the following function it returns nothing.

       

      Sum({$<ValidForYear={$(=Year(DeliveryDate))}>}NetMaximumCapacity)

       

      ValidForYear is the column with year and DeliveryDate is the Calendar date.

      I need to get the value from "NetMaximumCapacity" for the year selected by user based on data in other tables where "DeliveryDate" is used as date and time field.