If condition in set analysis

[mario-sarkis]

hey all ,

i have a main talbe that contain "date Name and Title" as

Date

first field   Name

second field   Title

is related to two table

i need to calculate the sum of points if TITLE: RM (from the first table) and the sum of [Br Points] if TITLE:ABM Retail (from the second table) and if no selection show the sum of two

hope you can help

REgards

‌

[robert_mika]

Could you post sample of your data or application?

[mario-sarkis]

‌unfortunatly i cant if u need any explaination i can explain more

[t_chetirbok]

you said that you have main table with 3 fields, what does it mean first and second table?

how your data model look like?

[t_chetirbok]

so, you need to calculate count of rows with title "RM" and count of rows with title "ABM Retail"

that's right?

[mario-sarkis]

‌yes the main table has date , name and title

and two others , the first one containt points and the second [Br Point]

if i select on name with title RM calculate sum of point and if i select on ABM need to calculate the sum of Br point

[t_chetirbok]

Your table doesn't have relation each other?

maybe something like this:

if(getfieldselections(Title)='RM',sum(Point),

     if(getfieldselections(Title)='ABM',sum([Br Point])))

[mario-sarkis]

‌thank you for ur reply but the problem the will not work when i select the name

[t_chetirbok]

can you explain once again what exactly are you doing and what should be display in report.

What objects do you want to use?

How your main table relates with other?

[mario-sarkis]

‌yes of caurse it will be a text box

my requirment is when i select the name if the title field is RM sum(points) and the title is ABM sum(Br points)