Skip to Content
0
Jun 08, 2020 at 02:26 PM

Product Availability in % - Combining different dimensions

60 Views Last edit Jun 08, 2020 at 02:27 PM 2 rev

Dear all,

I´m strugling to get a proper "Product Availability" using BO WebI formulas, maybe you can help me :-)

The main idea is quite simple: we have a list of products and if this product have stock > 0 it should be 100% availability, if their stock is =<0, then 0% availability. The problem comes when combining this with all selected stores and selected dates.

In Excel I´d just take the list of dates (1 month, for instance), stores and products and set a column next to them with the simple formula: if (Stock > 0 ; 1 ; 0) and based on this calculate the availability. The problem is that when I aggregate the information everything "crashes" and despite I´ve tried ForEach, In , Report, ForAll... formulas, I couldn´t make it work.

You find attached the Excel Logic what I unfortunately cannot get in BO.

Thanks a lot for your help!

Best regards,

Borja

availability-example.png

Attachments