Forum Discussion
Anonymous
7 years agoNot applicable
Subtract one column from constant value
Hi!
So I have a column as Driver Name, Avg Driver Score.
I want to perform (Avg Driver Score) - 4.85 and this value should appear next to all the drivers selected for a particular month.
When I do Measure = [Avg.DriverScore]-4.85, I get a list with all the driver names and not just the drivers selected for that Time frame.
For e.g.
I want something like this;
But instead I get list of all the drivers that are not a part of the selected time frame like this:
- Anonymous7 years ago
HI Anonymous ,
Perhaps you can add if statement with conditions to skip formula calculation on blank records:
Measure = IF ( [Avg.DriverScore] <> BLANK (), [Avg.DriverScore] - 4.85 )
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
HI Anonymous ,
Perhaps you can add if statement with conditions to skip formula calculation on blank records:
Measure = IF ( [Avg.DriverScore] <> BLANK (), [Avg.DriverScore] - 4.85 )
Regards,
Xiaoxin Sheng