Forum Discussion

poweruser55's avatar
poweruser55
Icon for Helper IV rankHelper IV
4 years ago

Count at least one flag

I have an app that calculates a few KPIS using flags.   It does this by using count of the flag. From there I need to add all of the counts together and divide by the total status count. There could ...
Need Help
bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Have been pondering. Think above

works but is inefficient. Would be better to use FILTER with some

or statements. Share some

demo data and conditions that need to be met and will

rewrite.

poweruser55's avatar
poweruser55
Icon for Helper IV rankHelper IV
4 years ago

I think I will also have to wrap something else in the final formula because when I apply the color conditioning formatting the OLI needs to be highlighted differently based on what it is flagging so for SD Date the shipment flag cells would look different than the Otherflag cells. Just not sure how to acheive this.