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

    String subtraction

    Sowmya Potluri

      Hi,

       

      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 !