2 Replies Latest reply: May 18, 2018 12:29 PM by Sunny Talwar RSS

    Formula Syntax

    Thomas Williams

      Hi,

       

      Can anyone please advise what is wrong with my formula please as I don't return any results when expected?

       

      alt(sum({<Period={"$(='>=201801<=2018' & Num(Month(Today()), '00'))"}, [Country] = {'UK'},Lookup={'ot'}>}Val,0)

      /

      above(sum({<Period={"$(='>=201801<=2018' & Num(Month(Today()), '00'))"}, [Country] = {'UK'}, Lookup={'ot'}>}Val,0)-1,0))