/profile-content.jspa?filterID=contentstatus[published]&targetUser=32379 Recent content in Tableau Community Forums en Tue, 11 Feb 2014 10:42:22 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2014-02-11T10:42:22Z en https://community.tableau.com/thread/138866 <!-- [DocumentBodyStart:04c934e3-2553-4cad-95fd-2e3c293f218e] --><div class="jive-rendered-content"><p>Dears Sirs, I'm a newbie and I was trying Tableau Desktop for a simple calculation, but there is something I don't understand.</p><p>In my example (see table) I have a calculated field '%' which is defined as '[s]/[i]' with number format as percentage with 2 decimal values.</p><p>I have another calculated field 'increment' which is defined as </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>ZN(SUM([%])) / LOOKUP(ZN(SUM([%])), -1) -1</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>, computed using "Pane Down" and with number format as percentage with 2 decimal values.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I don't understand how it gets value '4.05':</p><p>9.81 / 9.43 -1 = 0.040296</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>so I should get 4.03.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>This is my table:</p><table border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><thead><tr><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>s</strong></th><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>i</strong></th><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>%</strong></th><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>increment</strong></th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">22188</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">235339</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">9.43%</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">23061</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">235086</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">9.81%</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">4.05%</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Is there anything I don't understand?</p><p>Thanks</p></div><!-- [DocumentBodyEnd:04c934e3-2553-4cad-95fd-2e3c293f218e] --> Tue, 11 Feb 2014 10:42:22 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/138866 2014-02-11T10:42:22Z 5 years 4 months ago 8 0