Sentence With Script

[pgalvezt]

Hi,

I have this

Load

[conA1        ] + [conB1        ]  as TotalSum

From Table1;

My Expression Sum(TotalSum) thrown 5000

but I want to add an if sentence

Load

If([conA1        ] + [conB1        ] >0,'0', [conA1        ]+ [conB1        ])

as TotalSum,

From Table1;

My Expression Sum(TotalSum) thrown 4900

I need to appear 5000

How Could it be?

Thanks!

[eduardo_sommer]

You probably inverted the then/else in the if

Try with:

if([conA1   ] + [conB1   ]>0,[conA1   ]+[conB1   ], 0) as TotalSum,

Eduardo

[pgalvezt]

Hi Eduardo,

Still gives the same total 4900,

Thanks

[eduardo_sommer]

Can vou share your qvw or at least part of it?

Eduardo

[pgalvezt]

Eduardo,

The real result is -4714

The wrong result is 4874

Thanks!

[eduardo_sommer]

When I tried to open the app, it asked for a userid and password. Please, disable Section Access.

Eduardo

[Joseph_Musekura]

Hi,

Can you verify if, in the property of expression in you have checked Expression Total or Sum of rows?

This selection would affect the result

regards,

[Joseph_Musekura]

I did not mention that this concerns "straight table". If you have a pivot table , no need to check.

[pgalvezt]

Im Sorry,

Section Access was deleted,

Thanks!

[eduardo_sommer]

Good morning , Pablo

Why do you use Consumo12 in one object and Consumo12a in the other. The object with Consumo12a is giving you the result you expected.

Please, send me more details, since I don't have the data sources.

Eduardo