Forum Discussion

dw700d's avatar
dw700d
Post Patron
6 years ago
Solved

Using a switch or if statement for different conditions

I would like to create a measure that categorizes the "running total spend" column by  "Contribution type"     Running Total amounts less than 750k should be considered - Contribution 1 Run...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    dw700d 

    Try this, you can also use SWITCH,

    Contribution = 

VAR RT = [Running Total] RETURN

IF(
    RT < 750000,  "CONT1",
    IF( RT > 1500000,  "CONT3",
    "CONT2"
)
)

     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

Fowmy's avatar
Fowmy
Super User
6 years ago

dw700d 

Try this, you can also use SWITCH,

Contribution = 

VAR RT = [Running Total] RETURN

IF(
    RT < 750000,  "CONT1",
    IF( RT > 1500000,  "CONT3",
    "CONT2"
)
)

 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn