Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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:

  • Anonymous's avatar
    Anonymous
    7 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

  • Anonymous's avatar
    Anonymous
    Not 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