Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I face the following problem in my report.
Current Year (2016) is the Financial Year (2015-2016)
I need to do Current Year vs Last Year YTD Comparison. I am getting
correct numbers in LY YTD column, but when I click on the Year field, number
disappears and I get only hyphen.
Request anyone to help me out.
Thanks,
vidhya
Hi Vidhya,
Can you post a sample application. That would be much helpful.
Thanks and Regards,
Ankita
try this:
sum({<Date=,Date={">=$(=vLYMinDate)<=$(=vLYMaxDate)"}>}Exit_Count)
/
(sum({<Date=,Date={"=$(=vLYMinDate)"}>}OpeningBalance)+ sum({<Date=,Date={"=$(=vLYMaxDate)"}>}ClosingBalance))/2
Nope. it doesn't work