13 Replies Latest reply: Aug 27, 2018 1:36 PM by Sunny Talwar RSS

    how to use

    sony sing

      Hi all,

      Miguel Angel Baeyens de Arce

      Bala Bhaskar

      i want to use variable in alternate state expreession   below i tried but no luck   how to use?



      =Sum({<[Name] -= {"=len(trim([Name]))=0"},[L1]=$::[L1],[SRn]=$::[SRn],FormatId=$::FormatId>}[Amount])

      variable  is not workibng  here    but when i hardcode the value  its working   

      if i use variable data not showing anything


      variable:  vFormatId=FormatId

      format id is field  and having values  1000000,1000