5 Replies Latest reply: Sep 19, 2013 6:06 AM by Krishnan G RSS

    Inputbox for equal, less and greater than and Set Analysis

      Hi all!

      Please help me.

      I have Sales and I want to get sales where sales >,<,=N

      I use 2 inputboxes for  input “>,<,=” and for input TestNum =“N”.

      I use expression =If(sum(Sales)>TestNum, sum(Sales)) and If(sum(Sales)<TestNum. It works.

      I wanna use set analysis, but it works only witth 'If'.  See attachment.