Forum Discussion

DevadathanK's avatar
DevadathanK
Icon for Resolver I rankResolver 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>

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity 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
Icon for Resolver I rankResolver 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>