I am trying to create a calculation from "Value" Column depending on their Data type value.
Basically, it's Actual/Target.
I tried using the below formula but it just displays null values.
(if [Data Type]='Actual' then [Value] end)/(if [Data Type]='Target' then [Value]end))
I'd like to insert the result as a row under Target (Red arrow in the picture).
Appreciate the help!
2 answers
@Ivee Pendo can you try like below?
Sum(if [Data Type]='Actual' then [Value] end)
/
Sum(if [Data Type]='Target' then [Value]end)
Also can you share a sample .twbx file to have a closer look? May be you might have to use Some table calcs here to get this value under your actual/target.
