
1. Re: Table Calculations and Calculated Fields
Jim Dehner Sep 8, 2018 6:22 AM (in response to Wendy Brotherton)Good morning
Welcome to the forum
see the attached
I didn't get into the math bu mad 2 changes to the formulas
the first is to account for nulls in the data using zn() and the second was to aggregate the measures with sum()  you will want to check to see that is correct in the analysis
it returns this
BTW see Getting Started in the Forums for how to get the most out of interacting with the forum
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

forums_calc_example.twbx 584.1 KB


2. Re: Table Calculations and Calculated Fields
Wendy Brotherton Sep 9, 2018 6:13 AM (in response to Jim Dehner)Thank you so much, Jim! I have used ZN before and I'm not sure why it didn't occur to me that the calculation would return blank without it! That worked beautifully. Also, I did have the metrics switched in the calculation. When I switched the order of them it calculates correctly.
I appreciate your assistance!
Wendy

3. Re: Table Calculations and Calculated Fields
Jim Dehner Sep 9, 2018 6:20 AM (in response to Wendy Brotherton)Glad to help out
Jim