Forum Discussion

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
9 years ago
Solved

True and False with unrelated fields

So I know how to use the True and False clause when the values between two fields are equal and when they are not equal but I am unsure if its possible to use the True/False by validating parameters ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi JMWDBA,

     

    A little weird. The formula should work. Could you try the formula below to see if it works? :smileyhappy:

    Military Rate =
IF (
    'Registrations'[Term Military Civilian Type Descr] = "Civilian"
        && (
            ISBLANK ( 'Registrations'[Term Military Status] )
                || 'Registrations'[Term Military Status] = ""
        ),
    "No Military Rate",
    "Military Rate"
)

     

    Regards

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
9 years ago

For some reason it labels all of them as "Military Rate" based on the formula you provided instead of labeling those with Civilian and IS Blank in the Term Military Status Field as "No Military Rate"

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi JMWDBA,

 

A little weird. The formula should work. Could you try the formula below to see if it works? :smileyhappy:

Military Rate =
IF (
    'Registrations'[Term Military Civilian Type Descr] = "Civilian"
        && (
            ISBLANK ( 'Registrations'[Term Military Status] )
                || 'Registrations'[Term Military Status] = ""
        ),
    "No Military Rate",
    "Military Rate"
)

 

Regards

  • JMWDBA's avatar
    JMWDBA
    Icon for Advocate II rankAdvocate II
    9 years ago

    That worked like a charm!!! You are heaven-sent!!!:smileylol: