Problem with IF in the field statement

[Tony]

I have created form which part is a table with several rows for which I need to calculate the totals. I do not want to display total equal 0
My first question is what is the right syntax for the IF statement to use. I am trying

{IF{=SUM(LEFT)}>0 {=SUM(LEFT)} ""

but it is not working

Any suggestions

Tony

 

[Martin Seelhofer]

Hi Tony

Try using brackets around your condition (and remove any
spaces inside it):

{IF ({=SUM(LEFT)}>0) {=SUM(LEFT)} ""}

Works for me


Cheers,
Martin

I have created form which part is a table with several rows for which I

need to calculate the totals. I do not want to display total equal 0.

 

[Tony]

I have modified the IF statement to

{IF{=SUM(b1:d1)}<>"0" {=SUM(b1:d1)} ""

and all is working just fine now

Ton