Skip to Content
0
Former Member
May 02, 2018 at 06:08 PM

Create a Chart using the product of Running sum AND a constant

41 Views

Hi guys!

I'm trying for several days and still doesnt find how to do it in Crystal Report!

I want to create a chart with something like this :

On change of each record :
prj_date

show value :

TotalCostUPD = a formula that is the product of a running total sum AND a constant (rtotalsum of hours_worked * hourly_rate)

However, when i try to select TotalCostUPD in the Chart expert, i can't see it!

Thus, i cannot access database directly, so no way i could build views or procedure.

Does anyone know how to deal with this?

THank you!