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