-
A is monthly sales value.
-
CALC_2 function is below.
difference(sum({A}), [{YM_MAGAM_BI} DESC], 1, [truncDate('YYYY', {YM_MAGAM_BI})])
What i need is that the Jan 2023 value comes in to CALC_2 column.
I tried ifelse funtion like below
ifelse(
{FILTER_MONTH}=1, A
, difference(sum(A), [{YM_MAGAM_BI} DESC], 1, [truncDate('YYYY', {YM_MAGAM_BI})])
)
and It comes out error ““Mismatched aggregation. Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination.””
Is there any way to solve this problem…?