Expand my Community achievements bar.

How to Sum only if field is non blank?

Avatar

Level 1

I'm new to Adobe LiveCycle, I am trying to create a table that can sum the amount only if Product Number / Invoice Number is non blank. Please advise on to put together in FormCalc or JavaScript.  Thanks.

LiveCycle Question.JPG

1 Reply

Avatar

Former Community Member

Hi

Can you send your example form

From what I can see from your picture it looks like to need to sum all instances of the table rows if column 2 is not blank.

Is this correct?

Regards

Graham

DubDubDubDesigns.co.uk