Finding TotalSales

[NavinReddy]

Hi All,

i Need to be finding TotalSales if condision is Actual,

i Need to be finding TotalGain if Condition is Plan

Help some

Regards

Niranjan

[#2]

sum(Total if(field='Actual',Sales))

*****************************************

sum(Total if(field='Plan',Sales))

********************************************

or try this

sum(Total {$<field='Actual'}>}Sales)

*********************************

sum(Total {$<field='Plan'}>}sales)

[#3]

Hi Niranjan,

Plz share sample file.

Always try to post with sample qvw file with less data.

It will help us guide you quickly.

Karthiks

[er_mohit]

sum(total if(field='Actual',Sales,if(field='Plan',Sales))

or

sum(total if(field='Actual',1,sales))

or

try this sum(total<field>losses)

or

sum(Total {$<field=>}sales)