July 25, 2008 at 1:33 pm
Field Expression i would like to sum of the value based on other field data value.
Example
Fee value Condition Field
100 Salary
300 Tel Bill
500 Salary
output should be like 100+500 when the condition is salary.
how can i achieve it in expression?
July 25, 2008 at 8:09 pm
Look up aggregate functions in BOL. What you are looking for is a simple aggregate query using SUM and GROUP BY.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 26, 2008 at 11:52 am
I think you can do that with an IIF like this:
=Sum(IIF(FilterField=FilterValue, SumField, 0))
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply