0 Replies Latest reply on Oct 26, 2018 2:40 AM by Neha Tharani

    Python table calculation

    Neha Tharani

      Hello all,

       

      I have a bit tricky business requirement, let me try to explain it. In this picture attached I have Python created fields. My requirement is to created these stats fields that will be calculated based on the date selected from the slider and Returns calculated.  Python code calls a already defined function and calculates these stats,

      The data and output are correct. However, I have to keep all these into tool tip because they are repeated for every value of Date and Code in table.  I get the same stats for every blue box(detail) on the sheet. This is due to the fact that I have placed the dates on sheet. I want to show it only single time like in one table, with only stats and values no dates and codes on sheet but still used during calculations. I am not sure how to do that.

       

      Please let me know if further clarification is required.

       

      ps: I tried to upload a screenshot but I am not able to due to some privacy settings. Thank you for understanding.