2 Replies Latest reply: Apr 13, 2010 3:32 PM by Ana Garcia

# Please i need interpretation of this expression

Hello,

I'm having trouble developing some financial indicatiors, i'm doing something similar to the result of these expression, but i don't understand what it does :(

Ca anybody explain to me what does each part means???????????

sum({\$<Month =, Year = {"<=\$(#=only(Year))"},[Account - Report] = {'Balance'}>} \$([G/L Amount])) * max(total <[Account - Concept]> [Account - Factor])

thaks alot

ps I´m working with the plug in of SAP

• ###### Please i need interpretation of this expression

let me try to decipher the expression for you:

sum( - obviously, summary of the following:

{\$< - signified the beginning of the Set Analysis condition that respects most user selections, exept for the modified ones

Month =, - ignores user selection of the Month

Year = {"<=\$(#=only(Year))"} - this expression only applies to Years that are less or equal to the single selected/available Year (has to be only one)

,[Account - Report] = {'Balance'} - the field [Account-Report] need s to be equal to 'Balance'

>} - end of Set Analysis condition

\$([G/L Amount])) * - the actual expression that's being summarized is... I assume a variable called [G/L Amount] ??? (I can only speculate that the variable holds the name of the Field that should be aggregated)

max(total <[Account - Concept]> [Account - Factor]) - multiplied by the maximum of [Account -Factor] over the Dimension called [Account-Concept]

Something along these lines...

• ###### Please i need interpretation of this expression

Thanks so much!!!!!!!!!! this was exactly what I needed!!!!!!!!!!!!