@sumVs@sumrange
Hi,
first of all i want to wish you merry Christmas and a happy new year.
Product Hierarchy
G1 product
G2 100
G3 100-10,100-20,100-30
@sum (Sales, product)
Sales ->100-10 =100
Sales->100-20=200
Sales->300-20=300
The values should display Sales->100 =600 and then it has to roll up to top. Sales->product=600
@sum (Sales, Product)--> 600 and I am writing this values to budget sales but not going why?
Budget->Sales=@sum (Sales, product);
Q2) @sum (Sales, product) Vs @Sumrange (Sales, Relative (product, 0)
are these both the functions will return same values or not?
As per above equation(my assumption) @sum