26 Replies Latest reply: May 20, 2017 8:57 AM by Stefan Wühl RSS

    No results with set analysis

    Johan Kruize

      I use set analysis a lot and get (mostly) the results I expect.

       

      I think next expression is rather simple but it dont gives any result.

       

      In a table I have a date and an amount.

      Now I want to compare total amount with the total amount of previous month.

       

      Date is in a listbox.

      I have a variable : only(addmonths(getfieldselections(date),-1))

      The variable has the correct value when I show it in a textbox

       

      To calculate total sum of previous month I use the expression

      =sum({<date={$(variable)}>} amount)

      But result = -

      "

      Must be a very simple expression I suppose, but just don't see what I am doing wrong