6 Replies Latest reply on Oct 6, 2018 11:03 AM by meenu choudhary

    How to sum a calculate a field on top of another calculated field?

    Santiago Canon

           The current issue I have maybe a bit difficult to describe but I will do my best. Currently, in my workbook, I am experiencing duplicates at the product level so I created a calculated field to work around that. I wanted to know which individual products have not been quoted the past year so the answer should be 1 for not quoted and 0 for quoted, I worked around that by doing an if statement with % products not quoted the formula looks as such: IF [% Not Quoted] > 0 then 1 else 0 end which I named Prod Not Quoted. That worked great for me, however now I want do the count or sum(?) of products not quoted at the vendor level which would mean my products not quoted needs to be grouped by the vendor name. To be specific my objective is to provide a table of all products not quoted by vendor name without duplicates at the product level. What I tried to do is create a new calculated field using the previously which I calculated as the following: IF [Prod Not Quoted] = 1 then sum(1) else 0 end. The latter calculation, however, gave me the sum of all products quoted and not quoted along with the duplicates I am trying to avoid. Why would  IF [Prod Not Quoted] = 1 then sum(1) else 0 end not work?