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}