Please i need interpretation of this expression

[#1]

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

[Oleg_Troyansky · Accepted solution]

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...

[#3]

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