Forum Discussion
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...
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
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