Forum Discussion

DevadathanK's avatar
DevadathanK
Resolver I
6 years ago
Solved

Report refresh showing 'NaN' and 'Infinity' values.

Hi Community!

<Message deleted>

Thanks in advance!

 

Need Help
  • DevadathanK's avatar
    DevadathanK
    6 years ago

    I analysed the dataset and found out where the problem was occuring.

     

    I have a used a SharePoint list as a datasource, which contains a cloumn "TRUE/FALSE". This coulmn is getting loaded differently in Service. I had used a code snippet which involved a comparison function involving "TRUE". When this condition is evaluated in Service, the value returns a 0.

     

    <Message deleted>

     

3 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi DevadathanK 

     

    Could you plz kindly share your formula involved? 

    You might make a slight change on that with something like:

     

    Average= IF(ISERROR([Avarage_year_To_Date])=TRUE,0,[Avarage_year_To_Date])

     

    Also, please make the measure was set as a percentage in the desktop:

    • DevadathanK's avatar
      DevadathanK
      Resolver I
      6 years ago

      I analysed the dataset and found out where the problem was occuring.

       

      I have a used a SharePoint list as a datasource, which contains a cloumn "TRUE/FALSE". This coulmn is getting loaded differently in Service. I had used a code snippet which involved a comparison function involving "TRUE". When this condition is evaluated in Service, the value returns a 0.

       

      <Message deleted>

       

    • DevadathanK's avatar
      DevadathanK
      Resolver I
      6 years ago

      Hi v-diye-msft  Thank you for trying to help me,

       

      I checked my dataset in Service and found out where the problem was occuring. It led me to this data source in SharePoint that was giving a different value in Desktop and Service.

       

      The Formula i used for the Average in Desktop had a condition involving that value. When Service loaded the dataset, the value was getting changed and thus my formula wouldnt recognise it. 

       

      I added another condition in the formula with which it is working now. Showing you the screenshots below -

      The column was set to show the percentage value as you had asked. The Average however was taken in the visual directly, with the column value just calculating the overall percentage.