Hello, first post here, hoping you can help. I need to calculate impact of revenue for our fiscal year (9/30/2020) using a close date + 30 days from our sales funnel.
I calculated the daily revenue and then multiplied to remaining days in fiscal year from expected close date. Issue is that Expected Close Date is a field and is not part of the dataset and IsFTD filter below, therefore pulling other items in from our sales funnel. How can I fix this so it properly calculates impact?
=(Sum({$<DataSet={"Combined"}, IsFtd={'1'}>} AnnualValue)/365) * (274-DayNumberOfYear(ExpectedCloseDate)+30)
Thanks in advance.