Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm tryng calculate a sum of "Saldo Apresentação" limiting a dimension "Vencto" with a dates range, but my set analysis just work when i set a dimension. Can anyone help?
Points:
-I´ve more then one bases [Dt ACR] who have diferents [Vencto] inside;
-I want make a table with:
dimension: [Dt ACR];
metric: =sum Saldo apresentação limited by Venctos;
-"Vencto" need be in range ">monthend([Dt ACR], 0) <= monthend([Dt ACR],1)";
Actual result: my sum just work if i set one value on [Dt ACR]. But i need calculate the sum for each line (diferrents ranges).
Expected:
31/01/2015: sum({$<Vencto= {">31/01/2015<=28/02/2015"} >} [Saldo Apresentação])
28/02/2015: sum({$<Vencto= {">28/02/2015<=31/03/2015"} >} [Saldo Apresentação])
Hi Lucas,
The hard thing about doing this in your formula, is that you can't check if you're right..
Try to do this first in a table. First create the separate sections for your set analysis and see what the outcomes are. Then if that's is correct, stitch it together in set analysis. This makes it way easier to solve!
Jordy
Climber