8 Replies Latest reply: Feb 14, 2017 1:33 PM by Vineeth Pujari RSS

    Comparison using set expression

    Viral Mehta

      Hi,

       

      I have a dropdown 'Bank Name' and a field for grouping of banks called 'Peer Group' (values are 'Assets < 100 million', 'Assets between 100 and 300 million' etc.). I also have a measure 'Net Income' by bank.

      I want the user to select a bank from the dropdown and then show the 'Net Income' for the selected bank. Side-by-side, I also want to show the average net income for the 'Peer Group' that the selected bank belongs to. How can I do this? What will be the 'Set expression' to do this? See example below.

       

                              Selected Bank     Peer Group

      Net Income          $11,985            $7,500

       

      Thank you,