I have 3 data sources (Hardware, Database, Network). Each has a class field, which I want to return the value of.
Currently I am using the below calculation
IF
ISNULL([Class (Hardware)])
THEN
[Class (Database)]
ELSE
[Class (Hardware)]
END
This gives me the result of Hardware, and if hardware is null populates the Database information. I now want to introduce Network, but the variations I have tried haven't worked. Any Suggestions
3 answers
Hi, James
try this
IF ISNULL([Class (Hardware)]) THEN
if ISNULL([Class (Database)]) THEN
[NETWORK]
ELSE
[Class (Database)]
END
ELSE
[Class (Hardware)]
END
end
