6 Replies Latest reply: Apr 29, 2016 3:10 AM by Kshitija Shinde RSS

    Qs- Values reflecting

    Kshitija Shinde

      Hello everyone,

       

      So my question is that as seen in the below images the value in the cost column is reflecting while selecting some zone . The formula which i have used for Cost Column is :

       

      (92000/(Count(Total{<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])))*Count({<[Final Status]={'Dispute','Not Contactable','Verified'},[Caller Type]={'CSO'}>}[Client Code])

       

      What should i do to not reflect the values? Is there any alternative way?

      Untitled.png

        Untitled1.png