2 Replies Latest reply on Mar 22, 2018 4:42 AM by Sowmya Potluri

    String subtraction

    Sowmya Potluri



      i am using

      % change = (period2 data-period1 data)/period1data *100


      so i gave (int(attr([period2 data]))- int(attr([period1data])))/Int(attr([period1 data]))*100

      calc valid...


      but my data is showing Nulls and field in measures showing Agg(% change)


      here Period 2 data and period 1 data are strings.. how do i substract them


      can anyone help me !