8 Replies Latest reply: Jul 9, 2013 6:50 AM by Kristina Vodich RSS

    IF Function field in Set Analysis



      I need to apply date filter on expression in a table, which has values that are not connected with any CREATEDATETIME. So I need to apply this filter only on fields which are not null.Here is my set analysis which won't work.


      sum ({<[$(=if(not isnull(ZpoGr.CREATEDDATETIME),ZpoGr.CREATEDDATETIME))]= {$(='">='&DATE(zpgCreateDT_From2) & '<=' &DATE(zpgCreateDT_To2) & '"')}>}InvOut.AMOUNTCUR)


      Thanks for help


      UPD I have problems only with the left part of the expression - the right one works correctly