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

[DevadathanK]

Hi Community!

<Message deleted>

Thanks in advance!

[v-diye-msft]

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]

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. 

[DevadathanK · Accepted solution]

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>