Currency formula

[RavenXIII]

ok to start i have a formula that gives the remaining budget which is budget minus what they have spent if they overspend it will go in to a minus eg. $ -3,000.00

it is already a formula but how can i remove the minus symbol also if it is an overspend i want the field that says "Remaining Budget" to change to "Budget Overspend"

is some or all of this possible and how

Thanks

 

[Madawc]

To show Overspend, you could do something like

if {budget} >= {Spend}
then "Remaining Budget" & ToText({budget} - {Spend})
else "Budget Overspend" & ToText(({budget} - {Spend}) *-1)

You could also do two formula fields and put them in different columns, with one blank and the other showing either a remainder or an overspend.

You can also get rid of minus signs using right-click Format Field, but that's not the best option if you also want to use text. ToText is very useful and also has options for dates.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[RavenXIII]

Thanks it works