I'm building an OPEX report and for certain G/L Accounts (eg "913990") do I only want to include values were WBS number = "#" but for everything else I want it all
The example below works but as you probably see does not give me the correct sum... However I'm stuck when I try to do a "Sum(if(XXX,YYY))" formula so hope someone see how this can be done when there is a need of SET analysis in the expression
Example:
if(
[Account Number - Level 06 - [80ACCOUNT]]]='913990',
Sum({$< [WBS Element - WBS Element Level 01 - [20PS_PRJTYPE]]]= {'#'},
[Account Number - Level 04 (Text)]={'Other Opex', 'Total personnel expenses'} ,
[Version - Version Level 01 (Text)]={'*actual*'}>}Amount),
Sum({$<
[Account Number - Level 04 (Text)]={'Other Opex', 'Total personnel expenses'} ,
[Version - Version Level 01 (Text)]={'*actual*'} >}Amount))
//Kim
