Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi @simonas ,
You should add date field name in the set analysis as below:
RangeSum ( Above ( sum( {< FieldName= >} quantity ),0,rowno() ) )
Best Regards
not working RangeSum ( Above ( sum( {< FieldName= >} quantity ),0,rowno() ) ), getting values of current year
maybe i use wrong formula, i need to calculate all values always
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() ) )
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.