Need a help in if condition query....

[#1]

Dear All,

             I have a issue on below conditon .......

= sum (if(id=5,value) * if(id=10,value))

id = 5 is Qty

id = 10 is Rate

The above condition is showing zero....

Can any one help me...

Regards,

Antony.

[sivarajs]

sum (if(id=5,value,if(id=10,value)))

[#3]

Hi Sivaraj,

Thanks for your reply.

                    You conditon is adding both the values. but i want to multiply both the values.

Thanks,

Antony.

[its_anandrjs]

Try this

= sum (if(id=5,value) ) * sum( if(id=10,value))

Regards,

Anand

[#5]

Dear Aanad,

Thanks for your reply.

                             Your condition will not show the total value correctly due to sum of Rate. if i do the sum of rate and sum of Qty separately my total won't match. that is why im doing both the if condtion in one sum function.

Regards,

Napolean.

[its_anandrjs]

Can you provide any sample file for this or data file or sample data.

Regards,

Anand

[Anonymous]

Hi..

num(sum(if(id=5, value))) * num(sum(if(id=10,value)))

regards,

Akbar

[#8]

Dear All,

              Please find below the eg.

Product code	Id	Value
1	10	5
2	10	10
3	10	15
4	10	20
5	10	25
1	5	5
2	5	4
3	5	3
4	5	7
5	5	8

Sales = Rate (10)* Qty (5)

Sales Value i need 450

Regards,

Antony

[Anonymous]

Hi..

Let's try this :

sum(if(id=10, value)) * sum(if(id=5, value))

Regards,

Akbar

[its_anandrjs]

Sales = Rate (10)* Qty (5)

This columns Rate and Qty not in your eg please explain it.

Regards,

Anand