How to do write the expression in the chart of the report ?

[suvechha_b]

Hi All ,

How to do write the expression in the chart of the report ?

How can I get the result as  44190780

and Supplementary  13,262,567

My requirement is to show the total as 44190780.

Logic behind : 30 ,928,213 + 13,262,567 = 44190780

But currently , its showing  as 30 ,928,213 + (-13,262,567) = 17,665645

Sample model attached.

[arvind_patil]

Hi Suvechha,

Not getting what you want to write, I think,  You firstly mention what are the condition and logic need to get this value.

Thanks,

Arvind Patil

[suvechha_b]

Hi Arvind ,

My requirement is to show the total as 44190780.

But currently , its showing  as 17,665645

Thanks.

[prma7799]

My requirement is to show the total as 44190780.

But currently , its showing  as 17,665645

What is logic behind your expected output.

[suvechha_b]

Hi P M ,

Sorry My Mistake - for not explaining.

My requirement is to show the total as 44190780.

Logic behind : 30 ,928,213 + 13,262,567 = 44190780

But currently , its showing  as 30 ,928,213 + (-13,262,567) = 17,665645

[arvind_patil]

Hi  Suvechha,

I simply take text object and  Calculate =Sum(logistics_fee) and it gives me 17665645.62865 same output.It means there is missing something in your data. maybe it is a multiplier.

Thanks ,

Arvind Patil

[arvind_patil]

Hi Suvechha,

Just Multiply your second value by -1. So you will get your result.

Thanks ,

Arvind patil

[suvechha_b]

Hi Arvind ,

the sum result is correct.

Calculate =Sum(logistics_fee) and it gives me 17665645.62865

But , my requirement is:

30 ,928,213 + 13,262,567 = 44190780

The supplementary value is  (-13,262,567) , so , instead of deducting , I want addition.

if I use =fabs(sum(logistics_fee))  , the supplementary value is showing correct which is (13,262,567) , but I want  (13,262,567) value to be added.

But currently , its showing  as 30 ,928,213 + (-13,262,567) = 17,665645

[prma7799]

PFA..

[arvind_patil · Accepted solution]

Dear Suvechha,

Please you will get the idea from This:

=Sum({<[Customer Code Name]-={"Supplementary"}>}logistics_fee)+(Sum({<[Customer Code Name]={"Supplementary"}>}logistics_fee)*-1)

Thanks,

Arvind Patil