Forum Discussion

OsmanEmi's avatar
OsmanEmi
Frequent Visitor
5 years ago
Solved

Variable Usage - (VAR)

Hi,

I'm trying to understand variable usage and tried creating the mesaure below however, when put into a table the result is true/false as opposed to value.

Please can you explain where i'm going wrong and if my logic is flawed.

Measure is below the Target% measure is a %


Scoring System =
var CurrentScore = 0
Return IF(Target[Target%] > 0.98, CurrentScore = CurrentScore + 0, CurrentScore = CurrentScore + 1)
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    OsmanEmi , this can be like

     

    Scoring System =
    var CurrentScore = 0
    Return IF(Target[Target%] > 0.98,  CurrentScore + 0,  CurrentScore + 1)

     

    but are you expecting looping that will not happen 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    OsmanEmi , this can be like

     

    Scoring System =
    var CurrentScore = 0
    Return IF(Target[Target%] > 0.98,  CurrentScore + 0,  CurrentScore + 1)

     

    but are you expecting looping that will not happen 

    • OsmanEmi's avatar
      OsmanEmi
      Frequent Visitor
      5 years ago

      Hi Amit,

      Thank you this was what I was looking for.
      In terms of if I wanted to create a nested if that adds more to the variable would this still work?