Forum Discussion
melaniemdavis
6 years agoFrequent Visitor
IF Statement Help
We have a client database that has a main client ID with nested Sub client IDs EX: 123456.0000 123456 = Main Client .0000 = Sub Client 123456.0000 = Main Client 123456.0001 = Sub Client 1 12...
v-xuding-msft
6 years agoCommunity Support
Hi melaniemdavis ,
If the column of "Total Revenue" is created by formulas, you could add filters to exclude the data which is without Referral. For your requirement about hide the Client ID when there is no data of Referral, it is impossible. We just can set to blank values. The name of "Client ID" will still be shown in the visual.
If I understand incorrectly, please point out.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.