Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

IF Formula

Dear all,   I'm trying to get "Einzel" if the Document No is smaller than 300000 and "Vertrag" if the Document No is bigger than 300'000. For the moment I only get "Einzel". My goal at the end is ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    Try:

    Einzel =
IF ( SELECTEDVALUE ( 'Service Order'[Document No] ) < 300000, "Einzel", "Vertrag" )
PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

Try:

Einzel =
IF ( SELECTEDVALUE ( 'Service Order'[Document No] ) < 300000, "Einzel", "Vertrag" )