Set analysis

[Momin_3569]

Sum(
Aggr(
If(
Disc_Term_Kroger > Disc_Term_HT
and [Standard Uterms] = Standard_Uterms_HT,
(Sum(
{<QuarterYear = {'Q3 2023', 'Q4 2023', 'Q1 2024', 'Q2 2024'}, "Payment or Credit" = {'Payment'}, [Outlier Dates] = {'Good Dates'}, SOURCE={'Harris Teeter'}>}
NetInvAmt1
) / 365) * (bestcdays - BestdaysHT),
0
),
Norm_Vend_name, [Standard Uterms]
)

there is a defualt bookmark of SOURCE='ED' used in the application , i dont the above formula's calculation to change because of that. The value is changing because of the filer, i tried using 1 and SOURCE= in set but nothing works

[Kushal_Chawda]

@Momin_3569  try below

Sum({<SOURCE= >}
Aggr(
If(
Disc_Term_Kroger > Disc_Term_HT
and [Standard Uterms] = Standard_Uterms_HT,
(Sum(
{<QuarterYear = {'Q3 2023', 'Q4 2023', 'Q1 2024', 'Q2 2024'}, "Payment or Credit" = {'Payment'}, [Outlier Dates] = {'Good Dates'}, SOURCE={'Harris Teeter'}>}
NetInvAmt1
) / 365) * (bestcdays - BestdaysHT),
0
),
Norm_Vend_name, [Standard Uterms]
)