Conditional summing
Hi!
I have a question about conditional summing on a subreport. The pipeline has
a field (named type), which can have 2 different values. I calculate the
group using ordinary DBCalc component but I was wondering if there is a way
of having two DBCalc components, of which oe would sum the field Value only
when the the value in field Type would have value L, while the other would
sum the same but only when the field Type doesn't have the value L. Any
ideas?
Best regards,
Goran
I have a question about conditional summing on a subreport. The pipeline has
a field (named type), which can have 2 different values. I calculate the
group using ordinary DBCalc component but I was wondering if there is a way
of having two DBCalc components, of which oe would sum the field Value only
when the the value in field Type would have value L, while the other would
sum the same but only when the field Type doesn't have the value L. Any
ideas?
Best regards,
Goran
This discussion has been closed.
Comments
You need to use TppVariable components and the TppVariable.OnCalc event.
See the Calculations thread of the Tech Tips newsgroup for an overview of
how to perform calculations. Also see the Developers Guide and Learning RAp
end-user guid for tutorials on performing calculations.
DBCalc is limited to performing very simple calculations.
--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Regards,
Goran