Have you/they tried to do something like <%=IF(Cost>0,"","hidden")%> ? I'm not sure if it would work, unless you give the component the context of the object you're looking for Cost in. Or you may be able to use LookupObjectTotalValue? E.g. <%=IF(LookupObjectTotalValue(Servers,Cost)>0,"","hidden")%>
------------------------------
Oliver Smith
------------------------------
Original Message:
Sent: Fri January 31, 2025 07:15 PM
From: Richard Coronado
Subject: How to Setup Report Component Visibility Using Dollar Amount
Wondering if there is a way to set a component visibility based on a metric's amount. For example, showing Servers if the report component {cost} is greater than or less than zero?
Use Case: Hide Tabs/Components in a Drilled Down Report if the values such as {cost} in a particular component/ tab are zero.
Right now, there are certain components with visibility set if a particular component is installed (e.g. <%=IF(IsComponentInstalled("Storage"),"","hidden")%>) but hoping we can do it off of other things as well.
Asking for a friend here :)
------------------------------
Richard Coronado
------------------------------