AboveBeyond
Board Regular
- Joined
- Aug 14, 2007
- Messages
- 114
I have a calculated field like so:
Cars Sales Goal: = sum([Car Sold]/sum([Car Goal])
I click on "Create KPI" in the data model view and set the Absolulte Value to 1.
Wen I pull in the KPI field, all of the KPI icons are are one color (green) but there are clearly values less than (or greater) than 1. Also, when I change the icon style, the style doesn't change and gets stuck to the default circles.
Am I misssing something because I cannot get the KPI to work. Thanks!
Cars Sales Goal: = sum([Car Sold]/sum([Car Goal])
I click on "Create KPI" in the data model view and set the Absolulte Value to 1.
Wen I pull in the KPI field, all of the KPI icons are are one color (green) but there are clearly values less than (or greater) than 1. Also, when I change the icon style, the style doesn't change and gets stuck to the default circles.
Am I misssing something because I cannot get the KPI to work. Thanks!
