I would like to calculate the differences between each value of two lists.
The first list is complete, but in the second list are empty lists.
When I want to take the sum or difference from these lists, it only calculates the values when there’s one available in both of them. I would like to get the difference between every value of these lists, so when there’s an empty list it needs to take the value of the other list as result.
Does someone know how to do this?
I found one article where they suggested to do this in python, but this is posted in 2018.
So I would like to know if there is another solution then using python because I’m not familiar with it.
I would first start by simplifying the list structure in Math.Sum as that’s going to give you some additional trouble as well. Then it should just be an issue of converting empty lists to nulls. You could also add a 0 to all sublists before calculating the sum, since that won’t affect values but will ensure that all lists have at least one number to calculate with.