
1. Re: Quick Table Calculations with missing values
Naveen B Jan 16, 2019 7:03 AM (in response to john.garrigan.1)1 of 1 people found this helpfulHi John,
Create a calculation like below
zn(lookup(table calculated measure,0))
Hope this helps
In order to capture the Table calculation > Drag the measure to text > right click on the measure > Select Table calculation > Drag that table calculation with holding control > Place it in measures > a new field will be created (with naming as calculation ) > rename it > use this calculation.
Plz mark this answer as correct or helpful to close the thread
BR,
NB

2. Re: Quick Table Calculations with missing values
john.garrigan.1 Jan 16, 2019 7:58 AM (in response to Naveen B)Hi Naveen,
Thanks for the pointers.
I've created the new calculated field with a slight modification (ZN(LOOKUP(SUM([Mbr Count]),0))) and now I have zeros where I previously had blank fields.
For the last point I am a little stuck. I've dragged the new calculated field to text but when I right click I am not presented with the option to select table calculation, I have the following options available to me:
Do you mean to edit the table calculation? If so then I have the following options available

3. Re: Quick Table Calculations with missing values
Naveen B Jan 16, 2019 7:59 AM (in response to john.garrigan.1)already its a table calculation just you need to edit it how you want the addressing and partition
BR,
NB

4. Re: Quick Table Calculations with missing values
john.garrigan.1 Jan 16, 2019 8:04 AM (in response to Naveen B)Yes I have the table with 0's now but I can not run a quick table calculation on the "Test" measure.
How can I save this table as a new calculated field?