I've seen examples online of how to sum totals per distinct ID but unless I am missing something it is not working for me. If I sum charge I correctly get $244,102,899.29, just as in excel. If I remove duplicate ID's in excel I get $244,082.019.66 but I cannot get this number within Qlik. Can anyone help?
Based on the information in columns I and J in my sample data where I had excel remove duplicates I would expect Qlik to show the same $244,082,019.66 but it does not. If you use the data in Column A and B and look at ID 66761 and just summed you would get $1236.80 which is wrong. Sunny's expression gets me the correct $618.40 if I happen to filter on this receivable but it does not give me $244,082,019.66 with no selections. Aggr should give me the amount per unique ID right?