Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have one report, When I am not doing any selection, Output is correct, But When I am selecting Section ---> COGS Output is mismatching with entire output. I want only COGS data should to display there in reports. Another entire selection is working fine. But Section is not working. So Please help me on the same.
My Expresion :
Period 1 :
=if(GetSelectedCount(Section>1),
(If([P&L Level] = 's' , ' ',sum({Period_1<Section=$::Section,CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))),
If([P&L Level] = 's' , ' ',sum({Period_1<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))
)
Period 2 :
=if(GetSelectedCount(Section>1),
(If([P&L Level] = 's' , ' ',sum({Period_2<Section=$::Section,CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))),
If([P&L Level] = 's' , ' ',sum({Period_2<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))
)
For reference I am attaching with and without selection jpeg file.
Thanks in Advance