8 Replies Latest reply: Sep 14, 2010 8:49 PM by John Witherspoon RSS

    Set Analysis with <= Operator

    AndrewL

      I'd like to be able to use the less than or equal to operator (<=) in a Set Analysis expression, but it doesn't appear to work.

      The expression I have written is:

      =SUM({$<FinancialYear={$(=max(FinancialYear))}, PeriodNo<={$(PeriodSelection)}>} [ExtendedInvoicePrice])

      It seems as though the < symbol in <= is being related to the required < at the beginning of the statement (after the first $).

      Does anyone have any ideas on what I need to do to get this to work correctly?

      For info, this expression is supposed to return the total value of sales invoices in the current year (FinancialYear) up to and including the selected period (PeriodSelection).

      Any help would be much appreciated.