Hi, I am using indicators in my report where the datasource is coming from SharePoint lists. I want to use an indicator if there is a value, if there is no value then I don't want an indicator to show. Here is what I have but it doesn't work. If any one could let me know what could be wrong with it, please let me know. Thanks.
IIF(isnothing(Lookup(Fields!Data1.Value, Fields!Data1.Value, Fields!Data.Value, "Data"),"",1))