5 Replies Latest reply on Aug 14, 2019 7:38 AM by Kelly McGrady

    HELP REQUIRED WITH CREATING CALCALATED FIELDS

    VENKATSRIKANT BATTULA

      Can someone help me answer this simple question? I want to create calculated fields to answer below questions. I attached the Dataset below. Please answer ASAP. Thank you

       

       

      how to create a calculated field to count the rows where product="mango". Answer 4

      how find percentage of transactions where "mango" was purchased.Answer (4/11)*100=36.36%

      whats percentage that the fruit purchased was a mango out of all the transactions that had category="fruit".Answer(4/8)*100=50%

      create a calculated field to find count of Unique IDs that purchased "mango".Answer 3

      create a calculated field to find total cost for product= "mango".Answer 12