Hello everybody,
I have a problem with total calculation.
I have, a table with two rows name1 and name2
and two column A1(price) and A2(persentage(when is name1 1,2%, when is name2 1,3%) and I create third column A3 (A1*A2)
The calculation of third column works perfect, but when I create a total(A3) the value is wrong, the number is different by 1Euro or less, but still wrong. I try to change the aggregation (sum, calculate, total), try to make the calculation in report studio, then in FM but still doesn't work.
My model is relational. Report studio - list table
Š¢hanks in advance for your help.
Did you change the Aggregate Function to none?
Yes, but still doesn't work.
I think if is possible to create new column, with absolute values of column 3, because maybe the problem comes when cognos try to calculate two fields which have percentage calculation insight. Can you tell me, how to create new column with absolute value of column 3?