Using Set Analysis

[mustafaelryah]

Dear All,

     I have the below statement

     sum( {$<Account_Type2= {Expenses}>} debit)

its true but when I use value with space it cause an error like below statement:

  sum( {$<Account_Type2= {Operational expenses}>} debit)

and when I put it between '  ' the error been removed but no calculation !! like this below:

sum( {$<Account_Type2= {'Operational expenses'}>} debit) or sum( {$<Account_Type2= {[Operational expenses}>} debit)  also not calculated !!

Looking forward.

[its_anandrjs]

Hi,

If Account_Type2 holds value like Operational expenses as string then you have to use SET expression this ways in the single quotes or double quotes.

Sum( {$<Account_Type2= {'Operational expenses'}>} debit)

By this works definitely.

Regards

Anand

[mustafaelryah]

Kindly review my message , I typed this solution but not calculated !!

[its_anandrjs]

Can you share any sample file or what string in the Account_Type2 field.

Regards

Anand

[#5]

Hi Yagoub,

For me sum({$<Account_Type={'Operational Expenses'}>}Debit) is working.

Please find attached.

Thanks,

Chiru