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
if(Concat(DISTINCT Title)='RM',sum(Point),
if(Concat(DISTINCT Title)='ABM',sum([Br Point])))