14 Replies Latest reply: Feb 16, 2015 8:54 PM by DataExploiter _ RSS

    Basic calculated formula question in Designer

    DataExploiter _

      I need a calculated field to be used in a tree map to measure size. For example I use this in other applications. Sum(X)/Min(Y). Field X needs to be summarized for every record in the chosen beakdown. Divided by the first instance or min /max of field Y. ..Sum(X)/Min(Y). When I create a new calculated field I select my first measure X. This needs to be summarized. The function sum is not available, when I select Y and look for Min or Max the choice is not direct, min(Y) . Instead min(2,3) results is 3. How can I create a field in Designer to be used in a tree map, just like Sum(X)/Min(Y)? Thanks John