This content has been marked as final.
Show 6 replies

Error total sum field calculated
Peter Rieper Feb 27, 2011 2:35 PM (in response to Jordi Perez)Not quite clear  can you post an example.
In first instance would change the order of the aggregation and the condition, like SUM(IF ...)++
Peter 
Error total sum field calculated
Ashwin Pagare Feb 28, 2011 4:05 AM (in response to Jordi Perez)Can you share you apllication , as it little difficult to undersatnd here :)

Error total sum field calculated
Jordi Perez Feb 28, 2011 4:08 AM (in response to Ashwin Pagare)Dear Ashwin,
here you have a simple example
LOAD * INLINE [
F1, F2, F3,F4
1, 2, 6,D1
2, 1, 1,D2
];
Last field on total sum must be 9 and not 7
F4 Sum (F1)+Sum (F2)
Sum (F3) if(Sum (F1)+Sum (F2)>Sum(F3),Sum (F1)+Sum (F2),Sum(F3)) D1 3 6 6 D2 3 1 3 Total 6 7 7


Error total sum field calculated
Liron Baram Feb 28, 2011 6:30 AM (in response to Jordi Perez)you need to do an aggr function in pivot table
something like sum(aggr(if(Sum (F1)+Sum (F2)>Sum(F3),Sum (F1)+Sum (F2),Sum(F3)),F4))



Error total sum field calculated
Ashwin Pagare Feb 28, 2011 6:43 AM (in response to Jordi Perez)Hi ,
As per your expression its showing 7. but when you will do sum of Row's in straight table. It will give to your result.
In pivote it will work with aggr function
please find attach application.

Ashwin1.qvw 119.8 K
