Solved: Help with expression - Page 2

ABBA · 10-19-2022 10:27 AM

Hi

I am needing help with this

I got the expression correct but the results are not correct

IF
( AND
(OR
(
[Tank or Gauge Name]=“66018”,
[Tank or Gauge Name]=“Sales Tank #1”),

[Previous Day].[Total-Inches]< [Total-Inches]) ,
[Oil-Bbls]-[Previous Day].[Oil-Bbls],

"IF ([Tank or Gauge Name]=“11955”,[Previous Day].[Total-Inches]> [Total-Inches]) ,
[Previous Day].[Oil-Bbls]-[Oil-Bbls]")

@Steve

@MultiTech

Aurelien

What about this ?

IFS( 
  AND(   
    [Tank or Gauge Name]="66018",
    [Previous Day].[Total-Inches]<[Total-Inches]
  ),
    [Oil-Bbls]-[Previous Day].[Oil-Bbls],
  AND(
    [Tank or Gauge Name]="Sales Tank #1",
    [Previous Day].[Total-Inches]<[Total-Inches]
  ),
    [Oil-Bbls]-[Previous Day].[Oil-Bbls],    
  AND(
    [Tank or Gauge Name]="11955",
    [Previous Day].[Total-Inches]>[Total-Inches]
  ),
    [Oil-Bbls]-[Previous Day].[Oil-Bbls]
)

View solution in original post