Display Actual and Budget in one Module

AtzdGr8
AtzdGr8
in Modeling

hi everyone how can i display the actual budget according to the filter month that i have chosen. i have module Actuals and Forecast. and is it possible to change the color for actual as blue and orange for forecast? thank you.

ACTUAL BUDGET.jpg

Best Answer

  • Sai_Bharadwaj_Venati
    Sai_Bharadwaj_Venati
    Answer ✓

    You can write If else condition ⇒ If item(time) < Filter month then actuals else budget

    For coloring you should use conditional formatting in new ux. Conditional formatting line item formula would be if item(time) < filter month then 0 else 1; 0 means blue, 1 means red

    V.Sai Bharadwaj

    Connect on LinkedIn

Answers

  • PulkitChawla
    PulkitChawla

    @AtzDgr8 - Just to add on above which Sai mentioned, you need to keep timescale as months for the CF line item as we are defining the CF based on months.

Categories