Script calculation

[pgalvezt]

Hello,

I have to do a caculation I think better from Script: I have 1 table called Real I need to calculate 2 lines (Same calculation of excel as example)

If([cc_group_desc            ]='Dpto. Operaciones (Agrosystems)' and [cuenta                    ]='31020303' and Upper([subcuenta                ])='' and [cc                        ]='4400','AB',

If([cc_group_desc            ]='Dpto. Operaciones (Agrosystems)' and [cuenta                    ]='31020303' and Upper([subcuenta                ])='' and [cc                        ]='4407','AB',

Each line brings a number. Example cc=4407 brings for January 7.565.000 and 4400 brings 0 for January.

The calculation is (Line 1 + Line 2) - Line 2 * 0.73513

It would be (0 + 7.565.000) - 7.565.000 * 0.73513 = 1.881.416( Final Calculation)

How to do this in the script?

Thanks!

[pgalvezt]

Hi,

Any help?

Thanks!

[pgalvezt]

Hi,

Anyone can help me with this?

Thanks!

[miikkaqlick]

Hi!

Try something like this:

=(Above(Sum({$<Detalle_EERR={'AB'}> }Real) *-1)+Sum({$<Detalle_EERR={'AB'}> }Real) *-1) - (Above(Sum({$<Detalle_EERR={'AB'}> }Real)) * 0.73513)

It needs more finishing, but I don't have time now.

Br,

Miikka