Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a formula
Sum({ 1 <DATA = {'$(=MaxDATA)'} , [TYPE]={'a'}>} NONCHE)
The thing is that what I want is for this formula always show regardless on any filtration the sum for max DATA and this type. For example, in current dataset the max date is 01.01.2023. But if I do filtration for date, the sum shows for max date in selection. I need sum for max of all dates what are inside of application. I cannot show like 01.01.2023, because if dataset changes max date changes too
therefore dont know what to do
Create a variable to evaluate maxDate
example
vMaxDate1 =Max({1}DateField) << This will ignore ALL SELECTIONS
vMaxDate2 =Max({<ignorefield=,ignoreAnotherField=>}DateField) << This will ignore ALL SELECTIONS on specified fields
vMaxDate3 =Max({1<Yearfield=$::Yearfield>}DateField) << This will ignore ALL SELECTIONS EXCEPT on specified field
Your expression will then be
=Sum({ 1 <DATA = {'$(vMaxDate1)'} , [TYPE]={'a'}>} NONCHE)
Create a variable to evaluate maxDate
example
vMaxDate1 =Max({1}DateField) << This will ignore ALL SELECTIONS
vMaxDate2 =Max({<ignorefield=,ignoreAnotherField=>}DateField) << This will ignore ALL SELECTIONS on specified fields
vMaxDate3 =Max({1<Yearfield=$::Yearfield>}DateField) << This will ignore ALL SELECTIONS EXCEPT on specified field
Your expression will then be
=Sum({ 1 <DATA = {'$(vMaxDate1)'} , [TYPE]={'a'}>} NONCHE)
@vinieme12 thank you very much. It did solve my probem🙂