Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an expression i.e :
=
if(GetSelectedCount(Section1=1),
(If(([P&L Level] = 's' or IsAdjustment = '1'), ' ',Sum({Period_1<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName,Section1=$::Section1>}($(OpenBalanceExpression)+($(DebitExpression)-$(CreditExpression)))))),
If(([P&L Level] = 's' or IsAdjustment = '1') , ' ',sum({Period_1<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(OpenBalanceExpression)+($(DebitExpression)-$(CreditExpression)))))
)
Where I have to put a condition for OpenBalanceExpression that is :
Sum({$<MonthNum={$(vMinMonth)}>} $(OpenBalanceExpression) )
Only for OpenBalanceExpression
And I have written on variable
OpenBalanceExpression = OpenBal
DebitExpression = Debit
CreditExpression = Credit
Thanks.
If I get it right, you can go ahead like this:
Best,
Peter
Thanks Peter.
I accept the point for the same : Sum({SetAnalysis} OpenBalance) + Sum({SetAnalysis} DebitExpr) - Sum({SetAnalysis} CreditExpr)
Can you help me to make the same expression by using all parameter. I am using alternate states so that I am not able to make it.
My Expression :-
If(([P&L Level] = 's' or IsAdjustment = '1'), ,Sum({Period_1<CompanyName=$::CompanyName>}($(OpenBalanceExpression)+($(DebitExpression)-$(CreditExpression)))))
Thanks Again.