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

    How to combine two expression

    wajiha khan



      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??