i've this problem. PHOTO A has the result of automatic in the table. Photo b has the result when in the table i put total as sum. The problem is that i use this formula in a KPI and then i have the resul of PHOTO A while i want the result of photo b. Photo C is the script that i use: set analysis with distinct.