MEasure

[Anonymous]

Hi Guys,

i've created the below formula and it is working for only condition Unit = THM and not for Unit = DTH.

Does the formula picks only 1 condition at a time?

Annual Usage (DTH) = IF (

[typename] = "Nat Gas" && [Unit] = "THM" && [Unit] = "DTH",

ROUND ( [AnnualUsage] / 10.0, 0 )+0)+0

Regards,

Himanshu

[amitchandak · Accepted solution]

@Anonymous , Use || or In

Annual Usage (DTH) = IF (
[typename] = "Nat Gas" && [Unit] = "THM" || [Unit] = "DTH",
ROUND ( [AnnualUsage] / 10.0, 0 )+0)+0, 0)

Annual Usage (DTH) = IF (
[typename] = "Nat Gas" && [Unit] in{ "THM" , "DTH" },
ROUND ( [AnnualUsage] / 10.0, 0 )+0)+0 ,0)

added else part, change as per need

[AlB · Accepted solution]

Hi @Anonymous 

Annual Usage (DTH) =
IF (
    [typename] = "Nat Gas" && [Unit] IN { "THM", "DTH" },
    ROUND ( [AnnualUsage] / 10.0, 0 )
) + 0

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak · Accepted solution]

@Anonymous , Use || or In

Annual Usage (DTH) = IF (
[typename] = "Nat Gas" && [Unit] = "THM" || [Unit] = "DTH",
ROUND ( [AnnualUsage] / 10.0, 0 )+0)+0, 0)

Annual Usage (DTH) = IF (
[typename] = "Nat Gas" && [Unit] in{ "THM" , "DTH" },
ROUND ( [AnnualUsage] / 10.0, 0 )+0)+0 ,0)

added else part, change as per need

[Anonymous]

Thanks Amit for the help as usual 🙂

Regards,

Himanshu