4 Replies Latest reply: Mar 26, 2016 8:43 AM by KRISHNA VENKATARAMAN RSS

    if not exists and applymap coexists?

    KRISHNA VENKATARAMAN

      Hi Can anyone tell me if there is anything wrong with this if condition

       

                  If(not exists(Key, AutoNumberHash256([Transaction Invoice Date]),'MMM-YYYY') , [Transaction SAP Account Id] , [RO Id] ,[Transaction Product Code])), ApplyMap('Monthly_Manual_Rebates',Date(MonthStart([Transaction Invoice Date]),'MMM-YYYY') & '|' & [Transaction PAS Account Id] & '|' & [RO Id] & '|' & [Transaction Product Code],0)) as [Transaction Manual Rebates],

       

      I get an error

      Script error: Error in expression:If exists takes 1-2 parameters

       

      Capture.PNG

       

       

      also if you look at ths if condition in the picture there is a red for one of the brackets indicating that it is confused