Bucketing Value with condition

Question

Hello all,&nbsp;Im pretty new here, hope to get help from everyone to solve this case.&nbsp;Dummy table:&nbsp;Item&nbsp;ForecastTtl open order + ShipmentTtl Order - ForecastA12017555B22095-125C600-60D0100100Outcome i would like to get:Order vs forecast&nbsp;ForecastTtl open order + ShipmentTtl Order - ForecastOrder &gt; forecast&nbsp;12017555Order &lt; forecast&nbsp;22095-125Forecast without orders&nbsp;600-60Zero forecast&nbsp;0100100Total&nbsp;400370-30&nbsp;TIA 🙂&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous,
You can add a calculated column to check these two field values and return tags. Then you can use these fields to create a table visual to achieve your requirement:
Tag =
VAR diff = Table[Forecast] - Table[Ttl open order + Shipment]
RETURN
    SWITCH (
        Table[Forecast],
        diff, "Forecast without orders",
        0, "Zero forecast",
        IF (
            diff = 0,
            "Order = forecast",
            IF ( diff &gt; 0, "Order &gt; forecast", IF ( diff &lt; 0, "Order &lt; forecast" ) )
        )
    )
Regards,
Xiaoxin Sheng

Forum Discussion

Bucketing Value with condition

1 Reply

Related content

Sales bucket with bucket values set by slicer

Value conditional formatting

how to handle null values in if condition

Creating buckets/bins based on value ranges

Conditional Formatting - Bar Chart from Field values

Item	Forecast	Ttl open order + Shipment	Ttl Order - Forecast
A	120	175	55
B	220	95	-125
C	60	0	-60
D	0	100	100

Order vs forecast	Forecast	Ttl open order + Shipment	Ttl Order - Forecast
Order > forecast	120	175	55
Order < forecast	220	95	-125
Forecast without orders	60	0	-60
Zero forecast	0	100	100
Total	400	370	-30