Set analysis and dates - table

Lucas_Barros — Mon, 19 Apr 2021 20:21:45 GMT

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])

Re: Set analysis and dates - table

JordyWegman — Mon, 19 Apr 2021 20:44:40 GMT

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

topic Set analysis and dates - table in App Development

Set analysis and dates - table

Re: Set analysis and dates - table