Please can somebody help me with a formula (sorry new to crystal).

This is what I have tried and the idea is that I want to charge a different fee depending on session duration time:

 

If {'Cost_allocation_'.Session Duration} <> [00:05:00] then 2.50 else if {'Cost_allocation_'.Session Duration}> [00:05:00] then 5.00

 

I am using version 10 and the error is advising that a "the ] is missing"

 

Thanks

Colin

 

Any session duration not equal to 5 minutes will return 2.50, any that are equal to 5 minutes will return null as they're not greater than 5 minutes (your second if clause).

 

As for the error you're getting, try replacing the [ & ] with #.

 

If that doesn't work, I'd assume your Session Duration field isn't a datetime field and I'd need more information to help you (the datatype of the field).

 

Regards,

Ryan.

 

//NOTE if it = 00:05:00 then you still have 0 as a result. you may want one of these to also use an =