View Full Version : Formula problem!!


paul wolst
08-22-2007, 01:31 AM
how can i get a formula to not display when it returns the value false?
please can anybiody help, im new to crytsal. its vesion 8.5 if it makes any diff.

thanks very much

Kempes
09-18-2007, 12:46 AM
Right click on your section editor and edit. (On the left of the page).
Go to the details section and click on the formula button. (No tick required).
You will need to change the formula to suit your field but something like this should help.

If {yourfieldname} = false then true else false

This will remove the entire row where the value is false.
Basically, all this formula is saying is if the field value is false then suppress the row, otherwise show it.

Hope this helps

Kempes

boblarson
09-18-2007, 06:20 AM
Actually, if you click SUPRESS under the details Section the formula would be:

{yourfieldname} = False

That's all that's necessary as it tells it to suppress if the field name is false.

Mile-O
12-07-2007, 04:37 AM
Actually, if you click SUPRESS under the details Section the formula would be:

{yourfieldname} = False

That's all that's necessary as it tells it to suppress if the field name is false.

Same as I'd do, although I'd go for:

Not {yourfieldname}