3 Replies Latest reply: Sep 17, 2012 8:05 AM by lewiscooksey RSS

    Text Field to show value for current month & year

      As simple as =sum([Invoice Value]) for the total value, but i need this for the current month/year.


      I can easily acomplish this by using the Actions (Select in field =month(vToday) and =year(vToday))


      but i would like for this value to display automatically, like i have for value such as pending quotes etc (=sum({<[Quote Status]={'Pending'}>}[Quote Amount]))


      Is this possible to do?