4 Replies Latest reply: Jan 27, 2017 12:47 PM by Sunny Talwar RSS

    sum (or show field value) from the first day of the current month

    Eli Karp

      Hi all,


      I have data that is loaded in on the first of every month and I want to show that value or the sum of that day with set analysis. I've had some trouble with this heres what I've tried




      let vDateofData = Month(Today) & '/01/' Year(Today)  - Not sure if this is right I want it to show current month - then the first - then the current year so basically if it was june 5th 2015 I want it to show 06/01/2015.


      Then I want to sum that value (I Was having problems with get field value).


      I tried


      sum({<Date = {"=$(vDateofData)"} >} [Value]


      Not sure what the problem is. If anyone has suggestions or critiques they are welcomed.