A very challenging requirement using set analysis ?

[swarup_malli]

Hi!

i have a requirement , where i have to write a set expression with the requirments given below

where

i have to find the sum of donations by employee ,

  - with distinct account numbers  ( field name is      indacctno)

- exclude account number starting with zero

- where totaldonation > 0 ( field name is totaldonation ) in a year ( year is a field)

this is what i have written , now i have to implement the above requiremnts in the expression given below .

sum ({$<CAMPAIGNTYPE ={'Empl'}>} DCDetails.TOTALDONATION)

Regards

Swarup

[#2 · Accepted solution]

Hi Swarup,

I have attached a sample file which I hope provides you with a solution - the chart highlighted in "blue" in the bottom right reflects the correct results & total per my understanding of the problem.

The expression I used for the TotalDonations is as follows:

=sum({<indacctno -= {"= Match (left (indacctno,1), '0')"}, campaigntype={'Empl'}>} totaldonation)

For others who may read this post please note how 'value' must be surrounded by {} when used in a set expression e.g. {'Empl'}

BUT not if the 'value' is used inside a double-quote "statement..." e.g. "= ....., '0')" per above. There are no {} around the '0'

Hope this helps.

Cheers,

Craig

[swarup_malli]

Hi Craig,

Thank you for helping me out.

Regards

Swarup