Skip to Content
avatar image
Former Member

When Currency Sumup, one value is 0, the sum up value is blank.

Hi All,

I have a report with some formula to sum up a few formula value for example below.

{@TotalCharge}+{@Profit&Markup}

({@Profit}/{@TotalRev})*100

Noticed when one of the value is blank or 0 then my return value will be blank.

Both data type is currency.

Can anyone advise why is this so?

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 15, 2017 at 09:01 AM

    You need to either modify your formula to test for nulls

    Eg

    If isnull({valueField} then 0 else ......whatever your formula does.

    Or in File-> options check set database nulls to default. This is a bit more risky as it may have repercussions with other parts of your report.

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2017 at 01:06 AM

    Hi Ian, ,

    let said for {@TotalCharge}+{@Profit&Markup}, which mean I must check both {@TotalCharge} and {@Profit&Markup} if it is 0?

    If {CR073_ISSUES.CR073_AMT_03} = 0 then {@ShareNonBillCharge}
    else if {@ShareNonBillCharge} = 0 then {CR073_ISSUES.CR073_AMT_03}
    else {CR073_ISSUES.CR073_AMT_03}-{@ShareNonBillCharge}

    Is this correct? But I still get the same result.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2017 at 08:13 AM

    Hi Ian,

    I got it. Thanks!

    Add comment
    10|10000 characters needed characters exceeded