Expression Help.......................???

[aveeeeeee7en]

Hi Community

I am facing issue in Expression.

I have calculated [Gross Sales] from Script using GROUP BY Key

Now, I want to calculate      Percentage*[Gross Sales]

The Result i am getting is not desired output.

Kindly see the Attachment.

Regards

Aviral

[jagan · Accepted solution]

Hi,

Try this expressions

=Only(Percentages)*Column(1)

and

Avg(Percentages)*Column(1)

or Max(Percentages)*Column(1)

or Min(Percentages)*Column(1)

Regards,

jagan.

[Anonymous]

Hi Nag,

The numberw which are displayed in the Percentage*[Gross Sales] is correct.

If you calculate 298252*0.07= 20877.64 which is displayed correctly

Let me know what value you are lokking for.

[tresesco]

Re-write formula like:

=Sum(Percentages * [Gross sales])

[Anonymous]

sorry.Kindly ignore my previous message

Go to expression tab->Total Mode->Instead of Total Mode change that to Sum(below)

[aveeeeeee7en]

Thanks Sir

But the Expressions are not working.

[aveeeeeee7en]

Thanks Dass

But I don't want todo it that way.

I want tounderstand why it is not showing Expression Total.

[ashfaq_haseeb]

Hi may be like this.

Regards

AHFAQ

[aveeeeeee7en]

Thanks Ashfaq

But Acccording to your logic, i am getting different Results both in Table No.1 & Table No.2.

I want the Same Result i.e, 4779104.3938424 in Both Tables.

[aveeeeeee7en]

Thank You Jagan

I have used Only(Percentages)*Sum(GrossSales) from the Backend using Group By.

It worked like a charm.

Thanks Again.

Regards

Aviral Nag