2 Replies Latest reply: Dec 7, 2017 4:23 AM by wajiha khan RSS

    How to combine two expression

    wajiha khan

      Hi

       

      Can someone help me in one query

      I want one expression into another expression.

       

      =sum({<Year=,Month=,monthyear={">=$(=max(monthyear)) <=$(=addMonths(max(monthyear),4))" }>}fieldA)/5*fieldB

       

      Above is my first expression and i want my this calculation into below expression


      =Sum({<Item = {"=Rank(Sum(fieldB))<=30"}>} fieldB) // For top 30 Items


      Actually i want top 30 items but based on my first expression calculation.


      Is this possible?

      If yes then how??


      Thanks