Skip to Content
0
Former Member
Oct 11, 2006 at 06:38 PM

Calculate Formula previous to Sum

16 Views

Hi guys ...i have a problem....i have a formula that multiply a percentage and a quantity....and i obtain a quantity related...but i have in my infocube a monthly percentage and i want to show a yearly quantity related...and my formula dont work....apparently the formula sum all the values of percentage and sum all the values of original quantity and then multiply....of course its wrong...i need the formula apply for each month and multiply percentage x original quantity and the sum all the results in order to obtain the yearly result.....

Is there any way to do this with a formula?