Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I have a need to sum quantities and dollar amounts based on certain fields not being null / empty. The sum amounts need to be grouped by GROW --> Compute Grow and Storage Grow --> CIO as in the sample table below. I'm guessing the table needs to be a Qlikview Pivot Table though I'm open to suggestions or what will get the format close.
For the Compute Grow Volume (quantity) sum column and dollar amount sum column ($$$), the calculation should be based on the following:
I've attached sample data. The following is the output format needed, if possible.
As always, any and all help is appreciated.
I believe I have this solved with help from Peter Cammaert suing the following expression:
=(215 - (mid(Approved_YearMonth, 3, 2)*12+right(Approved_YearMonth, 2))) * [Monthly Spend]
I believe I have this solved with help from Peter Cammaert suing the following expression:
=(215 - (mid(Approved_YearMonth, 3, 2)*12+right(Approved_YearMonth, 2))) * [Monthly Spend]