Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am having problem in following expression: i.e. comparing two data fields along with one account code field.
sum({<Account = {'A1012304001'},DocDate <= BankReconDate>} ExtrCredit)
Help required please!
May be try this:
Sum({<Account = {'A1012304001'}>} If(DocDate <= BankReconDate, ExtrCredit))
or
Sum({<Account = {'A1012304001'}>*<Account = {"=DocDate <= BankReconDate"}>} ExtrCredit)
or
Sum({<Account = {"=Account = 'A1012304001' and DocDate <= BankReconDate"}>} ExtrCredit)
Actually I am trying to compare two fields (in set analysis) with each other, not having two fields in set analysis.
For that matter I used the following options, it does not work
1 .Sum(If(SOPostingMonth <> DOCreateMonth), RowTotalSO))
2. Sum({<DocDate -= DOCreateDate>} RowTotalSO)
I want to have summary of only those Sales Orders value whose date's months do not match with each other's
I also tried using the variables: but does not work
1. Sum(If(SOPostingMonth <> DOCreateMonth), RowTotalSO))
In continuation to my previous post. I am looking forward to compare two fields with each other instead of having two fields in set analysis. i.e. Month(DocDate) is not equal to Month(DOCreateDate)
Just pasting the data in tabular form as follows:
summary is just required for those whose Month(DocDate) is not equal to Month(DOCreateDate).
Month(DocDate) | Month(DOCreateDate) | Year(DocDate) | Sum(RowTotalSO) |
Feb | Apr | 2016 | 11,402,350 |
Feb | Mar | 2016 | 35,174,450 |
Feb | Feb | 2016 | 62,395,025 |