Ratio of outdated opportunities
Hi,
i want to calculate the ratio of outdated opportunities. I've got the following coloumns working.
- count all: "Revenue Metrics"."# of Open Opportunities"
- count outdated: FILTER ("Revenue Metrics"."# of Opportunities" USING Opportunity."Close Date" < current_date)
what does not work is the ratio column:
- ratio: FILTER ("Revenue Metrics"."# of Opportunities" USING Opportunity."Close Date" < current_date) / "Revenue Metrics"."# of Open Opportunities" * 100
basically it's a combination of the other columns, but I'm always getting "0" as a result. Anybody got an idea? I know, that there are other ways of calculating the ratio, but I neet this because I'm using column selectors.
i want to calculate the ratio of outdated opportunities. I've got the following coloumns working.
- count all: "Revenue Metrics"."# of Open Opportunities"
- count outdated: FILTER ("Revenue Metrics"."# of Opportunities" USING Opportunity."Close Date" < current_date)
what does not work is the ratio column:
- ratio: FILTER ("Revenue Metrics"."# of Opportunities" USING Opportunity."Close Date" < current_date) / "Revenue Metrics"."# of Open Opportunities" * 100
basically it's a combination of the other columns, but I'm always getting "0" as a result. Anybody got an idea? I know, that there are other ways of calculating the ratio, but I neet this because I'm using column selectors.
0