Jump to content

macability

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

macability's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hello, Can anybody help me with a SQL query problem which I have. I have 2 fields which I would like to add another 2 more fields with a calculation, one field calculates with a level return, the other is a 10% increase or decrease. For example the table will hold the following data Field_A : Field_B 1 : 1.4 2 : 1.7 1 : 1.3 5 : 1.0 3 : 1.0 I would like to only add field A if the result is 1 else I will want to subtract 1 . So I have an SQL statement which looks look like select Field_A, Field_B, SUM(IF(Field_A=1, Field_B.-1)) AS Field_C from mytable group by Field_A ; Field_A : Field_B: Field_C 1 : 1.4 : 1.4 2 : 1.7 : 0.4 1 : 1.3 : 1.7 5 : 1.0 : 0.7 3 : 1.0 : -0.3 What I would like to do for the next field (Field_D) is have it count up using a 10% increments for example: If Field_A=1 then I would like take a Field_B and multiply it by a 10% of the bank total. If Field_A does not equal 1 then decrease the bank by 10 % Field_D starts at 1 units Field_A : Field_B: Field_C: Field_D 1 : 1.4 : 1.4 : 1.14 2 : 1.7 : 0.4 : 1.03 1 : 1.3 : 1.7 : 1.16 5 : 1.0 : 0.7 : 1.04 3 : 1.0 : -0.3 : 0.94 Any advise people can give me will greatly be appreciated. regards Stevie D.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.