Basic Formula Zeroing Out

[kbfnet]

Hello!

I have a basic formula that is returning strange data:

The formula is:
vacaccr-vactaken=vac available
120-0=0

The formula should come back with 120 hours available but instead if someone hasn't taken any vaction hours the number is coming back as zero.

Any thoughts on how I can get the formula to come back with the actual vac available instead on zero?

Thank you!!
kbfnet

 

[johnvai]

can u explain more where u are using the formula? and how exactly?

 

[MrBillSC]

Check for null. If no vacation has been taken, maybe the value is null and the formula is calculating.

 

[kbfnet]

Hi Johnvai,

I would be happy to give you additional informaiton.
The formula is a free standing formula in a vacation accruel report. The actual formula is below:

({hrpersnl.p_vacaccr} - {hrpersnl.p_vactaken})

Does this help? If not let me know and I will supply additional informaiton.

Thanks!