topic AGGR function and IF statement in App Development

AGGR function and IF statement

Architect — Mon, 07 Nov 2022 18:13:15 GMT

below is an agg r function used in a chart.

sum(Aggr (If($v_RAGcolour) = 'R',1,0), store_id)) say output = 24.

0ur goal is to include another condition in the Aggr function.

Business_month = $v_last_month.

Hence our goal is to determine -

Sum of store_id where

1> ($v_RAGcolour) = 'R',1,0

2> Business_month = $v_last_month.

rubenmarin — Tue, 08 Nov 2022 08:06:44 GMT

Hi, can you try?: sum(Aggr (If($v_RAGcolour) = 'R' and Business_month = $v_last_month,1,0), store_id, Business_month))

oskartoivonen — Thu, 17 Nov 2022 21:52:38 GMT

This expression can probably be simplified by using Count(store_id) and filling in the correct set analysis.