Stop Calculation field going to a negative value i.e. -16

[mharkin]

Hi

I have a calculation field with the below calculation, the problem i have is that the field goes to a negative value, I want it to stop at 0.

Can someone please help me with this,

any help would be very much appreciated.

Thanks
Mark

 

[DJHunt]

I have a calculation field with the below calculation

...and just where is the code?

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US

 

[mharkin]

apologies here is the calculation:


Int((Date()-Contact2->UDCAABSDTE)*0.08/365*Contact2->UDCAABAMOU)+(Contact2->UDCAABAMOU)-(Contact2->UPAIDCLT+Contact2->UPAID2SGP+Contact2->UDCAPAYJUD)

 

[DJHunt]

You might have to use the iif() function. Something on the order of:

iif((Int((Date()-Contact2->UDCAABSDTE)*0.08/365*Contact2->UDCAABAMOU)+(Contact2->UDCAABAMOU)-(Contact2->UPAIDCLT+Contact2->UPAID2SGP+Contact2->UDCAPAYJUD))>0, 0, Int((Date()-Contact2->UDCAABSDTE)*0.08/365*Contact2->UDCAABAMOU)+(Contact2->UDCAABAMOU)-(Contact2->UPAIDCLT+Contact2->UPAID2SGP+Contact2->UDCAPAYJUD))

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US