set analysis -

[#1]

Hello,

I´d like to know, if is possible to join 2 set expressions (below) together  in one expression.

The expresions are:

1. sum ({1<Field_X={Budget}>} Value)

2. sum ({$<Project_Name>} Value)

I need to show value of Budget (full set of all the records) together with Project_Name (the records of the current selection)

It should be used in a bar chart where I want to display sum of Budget  for whole year independently of current selection of months and simultaneously the budget should change with a selection of type of Project_Name.

Is any different way to solve this problem?

Thanks

[#2]

I found one error - corrected and marked with Bold

Hello,

I´d like to know, if is possible to join 2 set expressions (below) together  in one expression.

The expresions are:

1. sum ({1<Field_X={Budget}>} Value)

2. sum ({$<Project_Name>} Value)

I need to show value of Budget (full set of all the records) together with Project_Name (the records of the current selection)

It should be used in a bar chart where I want to display sum of Budget  for whole year independently of current selection of months and simultaneously the budget should change with a selection of type of Project_Name.

Is any different way to solve this problem?

Thanks

[#3]

Hi,

try following:

Sum( {<AnyField=, Field_X={Budget} >} Value)

This would for Sum ignore every selection made over the field “AnyField”

[CELAMBARASAN · Accepted solution]

Hi,

     Check with this

      sum ({<YearField=,MonthField=,Field_X={Budget}>} Value)

Celambarasan

[#5]

Thank you very much,

it works greatly