Computation Error

[Robert1967]

I have 5 objects (customer,#of sales,$$of sales,$$ of returns, reason for return)in the data layer and 3 in the presentation layer (customer,#of sales,$$of sales).

Customer______#ofSales__$$ of sales___$$ of Returns
Jon Doe________151______$310,745.96___$ 35,075.00
Jane Smith______75______$104,511.90___$ 9,025.89
Pete Zondua____120______$279,715.95___$110,782.68

My expected data return would be to have....

Customer______#ofSales__$$ of sales
Jon Doe________151______$275,670.96
Jane Smith______75______$ 95,486.01
Pete Zondua____120______$168,933.27


The "$$ of Sales" is the Sales minus the returns. I am receiving computation errors when I attempt to calculate the returns out of the sale totals.

 

[fisheromacse]

are you objects formulas? if so, please show the entire contents of the formulas.
thanks

 

[Robert1967]

The object variable I created is below, and was developed to show return amounts based on the type of return.

The disposition type code is the return object; the codes provide of 22,32 are different types of returns.

= If <Disposition Type Code> InList(22 , 32)Then<Dispute Amount>*-1 Else <Dispute Amount>


The disposition type code is what need to be excluded from the results, but when I exclude them I receive the computation error. I tried to just hide it from teh format table section, but when I do it changes the format of my report.

 

[skrandel]

This sort of thing really should be done in the universe. The problem is that your are using and If statement. The thing in the IF needs to exist in the block. If it isn't there, you get the COMPUTATION error.

SO, you need to put Disposition Type Code in the block. This all works much better in WebI.

Steve Krandel
Intuit