topic Re: need not to change value in Visualization and Usability

need not to change value

simonas — Tue, 15 Nov 2022 11:35:05 GMT

i have formula for calculating :
RangeSum ( Above ( sum( quantity),0,rowno() ) )

i need to make values not change based on date filter. if i use total or {1} i get wrong values.

Re: need not to change value

agigliotti — Tue, 15 Nov 2022 11:54:52 GMT

Hi @simonas ,

You should add date field name in the set analysis as below:

RangeSum ( Above ( sum( {< FieldName= >} quantity ),0,rowno() ) )

Best Regards

Re: need not to change value

simonas — Tue, 15 Nov 2022 12:41:08 GMT

wrong

not working RangeSum ( Above ( sum( {< FieldName= >} quantity ),0,rowno() ) ), getting values of current year

good

Re: need not to change value

simonas — Tue, 15 Nov 2022 13:15:11 GMT

maybe i use wrong formula, i need to calculate all values always

Re: need not to change value

vinieme12 — Tue, 15 Nov 2022 14:48:33 GMT

can you post the exact expression you used?

from the expression posted by @agigliotti

You just need to replace FieldName with your actual field name that needs to be ignored

RangeSum ( Above ( sum( {< Yourdatefieldname= >} quantity ),0,rowno() ) )

Re: need not to change value

simonas — Wed, 16 Nov 2022 05:56:33 GMT

This is original: RangeSum ( Above ( sum( quantity ),0,rowno() ) ), then i added {<date field>} like @agigliotti suggested. i did not get result i wanted.

i need: to calculate all values with condition to add possitve value of previous months. Then i turn on date filter, i lose all possitive values of all month before filter and get only values in range of filter condition.