/profile-content.jspa?filterID=contentstatus[published]&targetUser=25741 Recent content in Tableau Community Forums en Thu, 08 Aug 2013 15:39:50 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2013-08-08T15:39:50Z en https://community.tableau.com/thread/129702 <!-- [DocumentBodyStart:9551f6d2-3ff7-4524-ba06-b2ee3569d19c] --><div class="jive-rendered-content"><p>Hello All!<br/>looking for some help here, hopefully someone can lend a hand.</p><p>My data look like this:</p><p>Manager Name - Associate Name - Scheduled Time - Actual Time</p><p>I have a calculated field that is saying if actual is &gt; schedule then 0 else schedule minus actual.&#160; This returns a zero when someone works more than scheduled, but a positive integer when they work less than scheduled.</p><p>when the data is displayed by associate, this is fine, but when trying to sum by manager, it calculates the total scheduled time and subtracts the total actual time.</p><p>What I need it to do is to calculate for each associate and then sum the results.<br/>Any thoughts?</p></div><!-- [DocumentBodyEnd:9551f6d2-3ff7-4524-ba06-b2ee3569d19c] --> Thu, 08 Aug 2013 15:39:50 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/129702 2013-08-08T15:39:50Z 5 years 11 months ago 1 0