Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have in my QV doc the following Pivot table of course prepared with help of you.
I want to modify this report show subtotal then the days total and grand total. My requirement is shown below
If this is possible kindly advise me how to do it. I also attach sample QV doc H/w
May be this?
=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto 21-Aug-2017', Date(DUE_DATE,'DD-MMM-YY'))
May be this?
=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto 21-Aug-2017', Date(DUE_DATE,'DD-MMM-YY'))
Try this.
It will allow you to set the date.
Regards,
Kaushik Solanki
Hi Anil,
Thanks a lot for your reply. I want a little thing clarified
=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto 21-Aug-2017', Date(DUE_DATE,'DD-MMM-YY'))
The above expression works well but since "Total Upto 21-Aug-2017" is hard coded It wont change with selection of due date
I have modified the expression but it does not work
=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto'&max(DUE_DATE), Date(DUE_DATE,'DD-MMM-YY'))
Pls correct my expression
I am sorry, I can't help y due to traveling till Tuesday.. May be offer you
Try with total keyword, like:
..'Total Upto'& Date(max(total DUE_DATE)-1)..
It works
=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto'&'-'& date(max(TOTAL DUE_DATE,'DD-MMM-YY')-1), Date(DUE_DATE,'DD-MMM-YY'))
only thing date appear as
Total Upto-8/20/2017 |
I want it to be
Total Upto-20-Aug-2017 |
Pls help
Use format code in date() like:
..'Total Upto'& Date(max(total DUE_DATE)-1, 'DD-MMM-YYYY')..
Thanks It works
Sorry,
Look forward to your help after your travel