Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Selected Value and If Statement

 I want to have the state selected show up as a title for the report, but if there is no selected state, I want it to just say USA. Any help would be greatly appreciated, as I have just begun t...
Need Help
Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

Anonymous ,

try this,

Selected country =
IF (
    HASONEVALUE ( financials[Country] ) = TRUE (),
    MAX ( financials[Country] ),
    "USA"
)

Thanks,

Arul