Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel formula - how to create similar formula in Business Objects
Hi Dell, thanks for responding to my request. I'm afraid my explanation wasn't all that clear - either that or I don't understand how to write the formula you suggest. Here I have made up some sample data to illustrate it better: B C D E Mat Nr Mat Nr Forecast =sumif(B:B,C2,E:E)+D2...- KrisAlesh
- Post #3
- Forum: Business Objects solutions
-
Excel formula - how to create similar formula in Business Objects
I am trying to create a formula in Business Objects similar to this Excel macro. =Sumif(B:B,C2,E:E)+D2. The formula is in column E. B Contains Material Nr at the supply location, C Material Nr at the delivery location, D Forecast at the delivery location. Thus this formula gives the total...- KrisAlesh
- Thread
- Replies: 3
- Forum: Business Objects solutions
