Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 11, 2020 07:08 PM
Aug 12, 2020 06:50 AM
Aug 11, 2020 09:06 PM
My first instinct on how to solve this would be:
Do you really need to see all those $0.00 values in your lookup field? Is it important to you to see all of those $0.00 values?
If not, just modify your lookup field to become a conditional lookup field by filtering out any records that have $0 as their value.
Aug 11, 2020 10:23 PM
Oh, and I should add:
If seeing all those $0.00 values IS important to you, then I think the easiest way to solve this would be to simply create ANOTHER lookup field where you conditionally filter out the $0.00 values, and then base your formula on THAT lookup field instead. You can also hide that additional lookup field so you don’t need to see it.
Aug 12, 2020 06:39 AM
Hi, yes the $0 is important because we field that auto generate value in that area.
Just want to ask how to filter out $0 if I create new field? I can’t determine.
Aug 12, 2020 06:50 AM
Create a conditional lookup:
Aug 13, 2020 06:01 PM
Thank you for your idea. I already get the output I need.
I used rollup and add condition not equal to = 0.
Aug 13, 2020 06:02 PM