Get seperate DB records in a cross table with a formula

Hi,

As my question suggests, I'm a beginner in Crystal Reports. I simply want to extract records from database and apply a formula on them at the same time.

I tried to create this formula :

WhilePrintingRecords;

ToNumber (Mid(Right (totext({ ...

The objective is to apply a formula to have a result for each column, but as you can see in the attached screeshot (red boxes), it only keeps the last column calculation.

Then a less important issue, what is this "second total column" (blue box) and how to get rid of it? 😊

Cheers,

Adam