Forum Discussion
OsmanEmi
5 years agoFrequent Visitor
Measure value is not dynamic when inserted into a table
Hi All,
I'm trying to create a scoring system for my table with a measure however whenever i insert the measure into the table I get just 1 value for all as opposed to it being dynamic for all rows. Can someone explain the logic behind it and what I'm missing?
Table and measure below, please note the -IN FULL (KPI) the measures refers too is also a measure and total value is 99.
1OIn Full Score =
var OnTimeScore = 0
Return
IF(-FACT_TRACKING_PERFORMANCE_UKIE[-IN FULL (KPI)] > 0.98, OnTimeScore + 0, OnTimeScore + 1)| Restaurant | KPI | Score |
| 1 | 98% | 1 |
| 2 | 90% | 1 |
| 3 | 94% | 1 |
| 4 | 99% | 1 |
Hi,
Remove the minus sign after the (.
2 Replies
- Ashish_MathurSuper User
Hi,
Remove the minus sign after the (.
- AnonymousNot applicable
This should not happened, what is the formulas for measure -IN FULL (KPI)?
Paul Zheng _ Community Support Team