Hello:
How to convert this Crystal report formula to an
expression in SQL RS ?
if {@.Date} <> minimum({@.Date}) then
(({ByMonth.CustomerCount} - previous({ByMonth.CustomerCount})) /
previous({ByMonth.CustomerCount})) * 100
Thank you.On Aug 12, 1:40 pm, GGill <GG...@.discussions.microsoft.com> wrote:
> Hello:
> How to convert this Crystal report formula to an
> expression in SQL RS ?
> if {@.Date} <> minimum({@.Date}) then
> (({ByMonth.CustomerCount} - previous({ByMonth.CustomerCount})) /
> previous({ByMonth.CustomerCount})) * 100
> Thank you.
Assuming that @.Date is a separate dataset (sourced via query/stored
procedure) used as a hidden parameter, etc.
Something like this should work.
=iif(Parameters!Date.Value <> Min(Parameters!Date.Value), ((Fields!
CustomerCount.Value - Previous(Fields!CustomerCount.Value))/
Previous(Fields!CustomerCount.Value)) * 100, Nothing)
If this does not fit your needs, you may want to set a flag field of
some sort (in the stored procedure/query that is sourcing the report)
to check against instead of a hidden parameter, etc.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
No comments:
Post a Comment