4 Replies Latest reply: Jul 8, 2013 6:44 AM by Bruno Santos RSS

    Evaluate String as Expression

    Bruno Santos

      Good morning,

       

      I'm trying to evaluate a string in a Pivot Table as an Expression, but it's not working...

       

      if

      (len(Expression1)<>0, Expression1, Sum($(vSetMTD) #Amount))

       

       

       

      Expression1:

      (aggr( sum(TOTAL $(vSetMTD_2Intersect)* <[Report Name]={'DRBI'},[Report LineNr]={'A25'} >}  #Amount),[Report LineNr])*-0.30)

       

       

      If I copy the cell value and paste as an Exporession, it works.

       

      Could you help me please.

       

      Thanks

      Bruno