8 Replies Latest reply: Jan 10, 2018 5:00 AM by Beck Bakytbek RSS

    compare the variables

    Beck Bakytbek

      Hi Folks,

       

      i got a situation, for instance: my data-area does look like:

       

      Project,Type, Turnover, Cost

      1, A, 75, 90

      2, B, 75, 78

      3, C, 36, 35

       

      i created 2 Variables:

       

      Sum({<Typ = {'*'}>}Turnover) and Sum({<Typ = {'*'}>}Turnover) i want to compare 2 Variables, if my Turnover is lower than my Cost, then the Cost need to be taken

       

       

      expected output is:

       

      Project,     Type,      Turnover,          Cost,   Compare Ratio

      1,                A,           75,                90,          90

      2,                B,           75,                78,          78

      3,                C,           36,                35,          36

      --------------------------------------------------------------------------

                                       186                203         204


      does any body have any idea ?

       

      Thanks a lot

      Beck