Function in Business Objects giving error

building reports webintelligence
1

Hi,

I want to write a fromula for the sum of the net value in each year based on part numbers. if the part number exist in both the years it should give me the sum of all those part numbers in respective years.

I have year as 2011 and 2012. first of all i created a check to see whether the part number exist in both the years or not.

=count(fiscal year in part number)

so its giving me value either 1 or 2

Now i want to sum the net value for 2011 and 2012 giving the condition if count is 2.
but its nt giving me the correct result.

please help

Seema Dhiman (BOB member since 2012-07-31)

2

Dont know what exactly you are displaying in your report window. However, Sum(Value) in (Partnumber) will sum up all the Values for all the years,partnumber wise

Regards,

Rmbodvp :india: (BOB member since 2010-10-14)

3

I want to get the total sales number in 2011 and 2012, only for the part numbers which are present in both the years.

for example:

lets assume i have 5 part numbers

part number 2011 2012
A 10 15
B 10
C 5 7
D 6
E 3

so for 2011 total sales for all those part numbers which are present in both the years is 15 and 2012 is 22

Seema Dhiman (BOB member since 2012-07-31)

4

You could create individual variables for 2011 and 2012 sales and then add them

For 2011 sales:

Case when nvl(2012_Sales) = 0 then 0 else sum(2011_Sales) end

For 2012 sales:

Case when nvl(2011_Sales) = 0 then 0 else sum(2012_Sales) end

Total Sales = Var_2011_Sales + Var_2012_Sales

nithya_raj (BOB member since 2007-02-03)

5

If you are displaying the results in the footer, a simple formula

If Count (parts) > 1 then Sum(Revenue) Else 0

should work.

If you want to display the results in the body, then you will have to define contexts properly but the formula should stay similar.

What is the formula that you are using?

mkumar (BOB member since 2002-08-26)

6

Crosstable and use the sum-function avialable in table.
And if you really want to see only when there are 2 years to a part modify the sum-formule to something like: if count(years) per part)=1 then sum(amounts)
goodluck

IngeH :netherlands: (BOB member since 2004-06-22)

7

I tried evrything, nothng is working :frowning:

Seema Dhiman (BOB member since 2012-07-31)