RE:Issue with Selection Criteria??

[priyav24]

Hello Everybody,

                            I have an issue with the selections,There is an calendar object in which the user needs to select the fromdate and todate which is working fine.But issue is when the user selects an account name ,the Previous selections is getting deselected..

Thanks in Advance ,

Priya

[Siva_Sankar]

couldnt able to open your attached file.

[Gysbert_Wassenaar]

If a new selection contradicts with existing selections then the existing selections are cleared. So if the account name doesn't have any data for the fromdate and todate then those two fields are cleared.

[priyav24]

Thanks @Gysbert,

                              so what can be done if i dont want show the account name in the straight table which is not in range of date..

[Gysbert_Wassenaar]

Perhaps changing the OpeningBalance expression to something like this works:

=if(sum(VoucherAmount),

num(Sum({$<GlDate={"<$(=Date(FromDate,'DD/MM/YYYY'))"}>} VoucherAmount+OpeningAmount), 'BD #,##0;(BD #,##0)')

)

[#6]

Hi Priya,

  The reason behind that is the data of account name is not having the those selection

Regards,

Santhosh G

[priyav24]

Thanks @Gysbert,

                              Could you Please Explain How it works

[Gysbert_Wassenaar · Accepted solution]

It first checks if there the sum of VoucherAmount is not zero. Perhaps count({<VoucherAmount={'*'}>} VoucherAmount) would be better since there could be transactions that when summed up have zero as result. The idea is first to make sure that there are transactions for that account in the selected period before calculating the opening balance. That's needed because that calculation overrides the GlDate selections.