I'm trying to use Exec:
=Sum(Fields.Total)/Exec('rptName', Sum(Fields.Total))
to calculate %.
But I'm getting 0.
Order and Sample are the result of the grouping
If I use only = Exec('rptName', Sum(Fields.Total)) I'm getting 64.
Can someone help me, please...
1 Answer, 1 is accepted
0
Hi Aleks,
Peter
the Telerik team
The division of two integers is also an int and therefore only the part before the delimiter is taken into account. Your expression should work with float values in order to return float values e.g.:
=CDbl(Sum(Fields.Total))/CDbl(Exec('rptName', Sum(Fields.Total)))
Peter
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items