var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sum if
I'm really new to crystal reports, but what I'm trying to do is really simple usually.
I would like to sum the field (orders.dollarvalue) if the field (orders.complete)= true.
I have the equation working well in access97 as:
=Sum(IIf([complete]=true,[dollar value of order],0))
but this doesn't seem to work in crystal. Does anyone know what the expression is that I should be using?
Thanks for helping out a newbie
Put this in a formula:
If (orders.complete)= true then (orders.dollarvalue)
Then sum this formula
Thanks a lot! That worked great. I guess the formulas are different in crystal reports from access and excel.