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])
      /$(vFormatId)



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



      if i use variable data not showing anything


      //1000000
      //$(vFormatId)
      //only({<FormatId=$::FormatId>}FormatId)



      variable:  vFormatId=FormatId


      format id is field  and having values  1000000,1000