Forum Discussion

vpatel55's avatar
vpatel55
Icon for Kudo Commander rankKudo Commander
4 years ago
Solved

ALL not ignoring column filter

Using the following code, I'm trying to get ALL to ignore a column filter. It should mean that all the colum values should be exactly the same. However, the values are different and ALL does not seem...
Need Help
  • vpatel55's avatar
    vpatel55
    4 years ago

    Hi, i'm afraid that the file is very big and contains sensitive data. In the end, I pasted into Excel and worked out manually. It could be a bug, as the code is otherwise what it should be. This will probably not have a solution, so feel free to delete the thread. Thanks.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

vpatel55,

 

last chance 🙂 

your 0,1,2... what is this field ? 

vpatel55's avatar
vpatel55
Icon for Kudo Commander rankKudo Commander
4 years ago

No problem Anonymous , its a table of grouped numbers. The data type is decimal, but changing it to whole number doesn't change the result. My ultimate goal is produce a cumulative percentage. So that '1' is x% of the total, 2 is y% of the total, etc.