Forum Discussion

powerboss's avatar
powerboss
Frequent Visitor
5 years ago

Value.Divide and List.Average giving Infinity and Null values

I am creating 2 reference tables off a source table. I am first grouping the first table into a "By Order" Average table, then grouping that table into a "By Part #" average table. By the time I get to the Part average table, I'm getting Infinities. 

 

Are there any consulters here who can do an hour or two? I can pay. 

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi powerboss ,

    This error may be caused by an inappropriate values(0, NULL or text value etc.) in the divisors. How did you create Order average table and Part average table? If it is in Power Query Editor, could you please provide some sample data of source table and applied step codes(exclude sensitive data) of new tables in Advanced Editor? Is there any column with 0 or null value?

    In addition, please check if the below method can resolve your problem.

    if [divisor]=0 or [divisor]=null then 0 else Value.Divide([Dividend],[divisor],0)​

    Best Regards

    Rena

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi powerboss ,

    Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.

    Best Regards

    Rena