If expression

[polisetti]

Hi ,

Please tell the expression ..I have a 'Sales Type' field in which it contains 'Units',  'Cash'...Now i want to calculate 'IPSales'

Ex: sales type= units ,i want sum of IPSales ...

Please give the expression in IF statement and Set analysis also......

[manideep78 · Accepted solution]

Set Analysis:

Sum({<[Sales Type]={units}>}IPSales)

Script:

Sum(If([Sales Type]={units}, IPSales)) as IPSalesSum

[polisetti]

Thank you Manideep

[polisetti]

If possible please give you mail  id ...

[manideep78]

You could be able to find my mail id in my profile. If you got what you required, please close it by marking it as correct answer. So that it will help others not to work on same question.