Hi,
I have a pivot table, Selection is lock, Please Unlock the apps.
- Selection à Year 2014 à Country – Israel, GL ACoount à TOTAL CASH AND CASH EQUIVALENTS – 724622.32 is coming.
By Using this Expression:
if(GetSelectedCount(Section1=1),
(If([BS Level] = 's' , ' ',Sum({$<MonthNum={$(vMinMonth)}>} $(OpenBalanceExpression) )))+
(If([BS Level] = 's' , ' ',sum({<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName,Section1=$::Section1>}($(DebitExpression)-$(CreditExpression))))),
(If([BS Level] = 's' , ' ',sum({<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))))
But Output is wrong : It Should be : 1,709,807 on the same selection.
But when I am using the this expression Output is coming correct but my Report chart format is mismatch and output is correct.
Expression :
Num(If([BS Level]='s',' ',(Sum({$<MonthNum={$(vMinMonth)},Year=$::Year,Month=$::Month,CompanyName=$::CompanyName>} $(OpenBalanceExpression) ))),'##.##')
+
Num((If([BS Level]='s',' ',(sum({$<Year=$::Year,Month=$::Month,CompanyName=$::CompanyName>}$(DebitExpression)))))-(If([BS Level]='s',' ',(sum({$<Year=$::Year,Month=$::Month,CompanyName=$::CompanyName>}$(CreditExpression))))),'##.##')
But I required same report format with correct output.
For more ref. please find the attached qvw and jpeg.
- Thanks.
