Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

MEasure

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

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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's avatar
    AlB
    5 years ago

    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 

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks Amit for the help as usual 🙂

       

      Regards,

      Himanshu

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    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