Less than and greater than

[catherine26]

What is the best way to do the presence event when working with totals.  I created a table for funding and based on the total the document needs certain signatures.  For example if the total is more than $10,000 signatures VP and Approving Officer need to appear.  If the total is less than or equal to $10,000 than the Approving Officer signature only appears.  Any help on this would be much appreciated...thanks so much!

[Srini_Dhulipall]

Assuming rawValue of the total field is returning as "10000".

In the Calculate event of the Total field, write the following with Java Script as language.

VP_Signature.presence = "hidden";

Officer_Signature.presence = "hidden";

if(total.rawValue>10000){

     VP_Signature.presence = "visible";

     Officer_Signature.presence = "visible";    

}

else{ 

     VP_Signature.presence = "hidden"; 

     Officer_Signature.presence = "visible";

}

Thanks

Srini