on 09-26-2008 3:13 AM
Hi,
i have converted one deski document to webi through Report Conversion Tool. the original deski contains one variable with the computaion
"= If <Alloc(Slow Mover)> ForAll <MP Customer(Slow Mover)> =0 Then "MAIN RUNNERS" Else If(((<T/O Pcs(Slow Mover)>+<T/O Pcs GIT(Slow Mover)>)/<Alloc(Slow Mover)>) ForAll <MP Customer(Slow Mover)> > 0.3) Then "MAIN RUNNERS" Else "SLOW MOVERS" "
the converted formula in webi is
= If( Alloc ForAll (Slow Mover.MP Customer) =0 ; "MAIN RUNNERS" ; If((((Slow Mover.T/O Pcs+Slow Mover.T/O Pcs GIT)/Alloc) ForAll (Slow Mover.MP Customer )> 0.3) ; "MAIN RUNNERS" ; "SLOW MOVERS" ))
when i run this in webi i get "#COMPUTATON" in the report data for that formula instead of the computed value. when i tryto edit variable in webi , it say's invalid datatype for Alloc, eventhough it is a number, it is taking the value as string. it is working fine in DESKI.
please help to give suggstions
thanks
srivani
Try an re-create the formula in Webi and check the behaviour.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.