CLewis
01-28-2022Cloud Apps
Using answer to a calculation within another calculation
Im looking to use the answer from one calculation in another calculation on a separate widget with different filter set up.
This is my first calculation, it counts how many sales we have prior to drafting for each model and divides by the total number of sales. This then shows the percent sold prior to drafting for each of our models.
(count([UniqueJob]), [SoldPriorToDrafting], [Years in FinalSaleDate]) / (count([UniqueJob]), [Years in FinalSaleDate])
The problem is I don't want the calculation to run first on the new widget I just need to use the number from the pivot table above as the other widget shows each individual job within the model. The calculation doesnt work when looking at it in this view.