Having a cell not populate without specific data

[JetFixxxer]

I have a total field for a simple calculation from data from two other fields.     What I'm trying to do is have the total field not populate if one of the two data fields doesn't have data.   I would like also for the total field to be greyed when total = 0 or less.

[Nesa Nurani · Accepted solution]

For calculation you can use this:

var a = this.getField("Text1").value;
var b = this.getField("Text2").value;
if(a == "" || b == ""){
event.value = "";}
else event.value = a+b;

For grey out , you want border and fill color (or just fill color) to be grey if value <= 0? And what color should it normaly be?

[JetFixxxer]

Thank you, much apprieciated.

I would like it to be just fill color.  It's normally white and would like it to be grey when not populated.

[Asim123]

And what if value is empty what color then

[Nesa Nurani · Accepted solution]

Add this to the code:

event.target.fillColor = event.value <= 0 || event.value == "" ? ["G",.7 ] : color.white;

[JetFixxxer]

Thank you once again.