Minus im Skript

[#1]

Hallo zusammen,

ich möchte meine Traded Werte von meinen Cleared Werten Abziehen und schreibe im Skript folgendes.

'Cleared Volume'    as Volumekey,

    'Cleared Volume  -Traded Volume' as [Give up/ Take up],

Leider Addiert er anstatt zu subtrahieren.

Weiss einer woran das liegt?

VG

Laura

[Anonymous]

we are not able to help you without a sample qvw or at least your script

as subtracting works well in Qlikview it must have todo with the content of your fields

[#3]

'Traded Volume'

as Volumekey,

'Cleared Volume'    as Volumekey,

    'Cleared Volume  -Traded Volume' as [Give up/ Take up],

That is the part from my skript.

[Anonymous]

I think  Field names should be Unique within the table

'Traded Volume'

as Volumekey,

'Cleared Volume' as Volumekey2,

   (Cleared Volume  -Traded Volume)as [Give up/ Take up],

[#5]

I´ve allready try that. its unfortuantely not the problem

[Anonymous]

one last thing before I give up without more information

try

Load *,

Volumekey - TradedVolume as  [Give up/ Take up];

load

[Cleared Key] as Volumekey,

[Traded Key] as TradedVolume,

..

[Anil_Babu_Samineni]

As I know,

Please take text object

Sum(Cleared Volume)  - sum(Traded Volume) and see whether the values are coming or not.

OR

Fabs(Sum(Cleared Volume)  - sum(Traded Volume))

Note: I don't know what is the traded volume.