1 Reply Latest reply on Oct 7, 2018 5:55 PM by Joe Oppelt

    How to sum a calculated field from a separate calculated field?

    Santiago Canon

      I currently have two tables. My first table is my products table and what I am trying to visualize in the product table is the number of products quoted or not quoted the past year. So, I have '1' for product not quoted and '0' for products that are quoted. I was able to calculate these measures by creating a calculated field from a percentage measure where if products not quoted is 100% then that means it has not been quoted and if it is 0% then it has been quoted. However, when I try to roll up at the vendor level I cannot get my products not quoted equal to products not quoted at the vendor level. I have some duplication issues so that is why I had to resort to the measurements I just mentioned.