set analysis show max date regardless any filter including date

[Madina]

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

[vinieme12 · Accepted solution]

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)

[Madina]

@vinieme12  thank you very much. It did solve my probem🙂