topic Re: Block 0 value lines? in App Development

Block 0 value lines?

stephenhasson — Tue, 13 Feb 2018 18:00:57 GMT

In above chart, I want to remove lines where there is no delta in qty.

Detla qty is =sum(OurReqQty)-sum(Open_Order_Quantity__c)

I have tried this

if( sum({1}OurReqQty)-Sum({1}Open_Order_Quantity__c)=0,0,sum(OurReqQty)-Sum(Open_Order_Quantity__c))

and switched off 'show zero values' in Add-ons, but didn't work. A similiar approach worked on another app recently, but not this time.

Any help appreciated. thanks.

Digvijay_Singh — Tue, 13 Feb 2018 23:50:36 GMT

Do you have any other measure with non zero values, I think it only switches off zero values when all measures in a row produces 0 values.

john_obrien — Wed, 14 Feb 2018 03:15:14 GMT

Stephen,

You will need to wrap all the expressions in this chart in If statements like this:

if( sum(OurReqQty)-Sum(Open_Order_Quantity__c)=0,0,sum(OurReqQty)-Sum(Open_Order_Quantity__c))

if( sum(OurReqQty)-Sum(Open_Order_Quantity__c)=0,0,sum(EpicorValue))

I don't think the set analysis expression is needed in the If condition - if( sum( {1} ...

Without it, the If condition will use the same set of data that the rest of the expression does, so each row shows or hides as it should.

I hope that helps.

stephenhasson — Wed, 14 Feb 2018 16:18:21 GMT

Thanks for you reply, now resolved, as I removed the other columns.

stephenhasson — Wed, 14 Feb 2018 16:18:49 GMT

Thanks for you reply, this worked great