LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

Multiplying where field is null

  • 1.  Multiplying where field is null

    Employee
    Posted 04-30-2015 00:34

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: UisceBeatha

    Hi,

    I've come across an issue yesterday where if records in a field are null and the field is multiplied by a value Lavastorm seems to treat the null as a 1 instead of 0 and so outputs the incorrect value. For example if I have a record with a null, 0, 1 and multiply each of these by 1.2 then I would expect the results to be null (or 0), 0 and 1.2 respectively however the results are 1.2, 0 and 1.2.

    I've attached a copy of the graph which shows this occurring. I can resolve this going forward by using if statements however this anomaly has produced some incorrect analysis for our business so I need to be able to explain why it's occurred. Is this a bug or expected? Is there anything else I should be aware of? Multiply Nulls Issue.brg

    The version of BRE we are using is v 4.6.1.2 Build 489

    Thanks