Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you post sample of your data or application?
unfortunatly i cant if u need any explaination i can explain more
you said that you have main table with 3 fields, what does it mean first and second table?
how your data model look like?
so, you need to calculate count of rows with title "RM" and count of rows with title "ABM Retail"
that's right?
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
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])))
thank you for ur reply but the problem the will not work when i select the name
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?
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)