Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Script

I have two fields [Expected Send] and 'Opened'

I want to create a field called SentToOpenRate, by dividing 'Opened' by [Expected Send]

Can this be done in the script? If so, what is the proper structure?

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

Opened/[Expected Send] as SentToOpenRate,

If [Expected Send] and be null or zero, you'll need an IF to work around that.

View solution in original post

2 Replies
m_woolf
Master II
Master II

Opened/[Expected Send] as SentToOpenRate,

If [Expected Send] and be null or zero, you'll need an IF to work around that.

aarkay29
Specialist
Specialist

May be this,

[Expected Send] / Opened as Cal