2 Replies Latest reply: Aug 18, 2015 12:06 PM by Piet Hein van der Stigchel RSS

    Is it possible to use the OMIT function in Section Access with a IF statement for some kind of condition?

    John Blomqvist

      Hi all

       

      Is it possible to use the OMIT function in Section Access with a IF statement for some kind of condition?

       

      For example I have a SalesAmount field.

       

      For some charts, for some users I want to show the result of Sum(SalesAmount) where it exceeds 100,000 in value otherwise display 0.

       

      So out of 10 users who have access to the application, for some users I want them to see all the values, but for others I want them to only see results where Sum(SalesAmount) exceeds 100,000.

       

      Is this possible?