Hi,
I have created a calculated group with multiple calculations and formats. The issue I am running into is getting the Negatives to be Red. I tried many videos online with solutions, but cant get it to work.
This one only seems to work when you dont have multiple different calculations.
https://www.youtube.com/watch?v=ToAlPA5KvUc
This one seems better, but cant get the Red in the formula.
https://www.youtube.com/watch?v=90X5_tISxIY&t=527s
Not sure what I am doing wrong or where to go from there. Would love some help Thanks so much!
Here is my recent try at adding in an If statement to the Switch function with my calculations.
Switch(
True(), Selectedmeasurename () = "Net Profit CY", Format([Net Profit CY], "$ 0,0"),
Selectedmeasurename () = "Net Profit LY", Format([Net Profit LY], "$ 0,0"),
Selectedmeasurename () = "Net Profit VY", Format([Net Profit VY], "$ 0,0"),
if(Selectedmeasurename () = "NP % +/-" && >=0, Format([NP % +/-], "0.0%"), "Red" && Format([NP % +/-],"0.0%; -0.0%")),
