sum of two dataset values RRS feed

  • General discussion

  • Hi ,

    I have created an RDL file with two datasets and everything is except one of the coloumn. I need to sum two values in the coloumn which are taken from 2 different data sets .following is the expression which I tried but not working

    =Format(DateAdd("s",Sum(Fields!VALUE.Value)* 60,"00:00:00"), "HH:mm:ss")+Format(DateAdd("s",Sum(Fields!UpTime.Value, "ARCHIVE1") * 60,"00:00:00"), "HH:mm:ss")

    Saturday, September 21, 2019 8:55 AM

All replies