Getting a % when the numerator and denominator are derived basis conflicting condition

Question & Answer
, , ,
1

Hi all,

I’m trying to get a value by dividing 2 ifelse statements but I get a 0.
image

Individually I see the numerator and denominator values though.

Formula for Revmultiplier_NonPremium_to_PVODPEST:
ifelse({Window_type}=‘Non-Premium’, selectedtitlesrevenue, 0)/ ifelse({Window_type}=‘PVODandPEST’, selectedtitlesrevenue, 0)

Formula for RMultest1:
ifelse({Window_type}=‘PVODandPEST’, selectedtitlesrevenue, 0)

Formula for RMultest2:
ifelse({Window_type}=‘Non-Premium’, selectedtitlesrevenue, 0)

I think its because of the conflicting conditions of the ifelse. If so how do I get the value and is there a better way to achieve what I’m trying to do?

Thanks in advance!

Regards,
Tanisha

2

Hello @Tanisha_Shetty !

Could you try something like this instead:

sumIf({selectedtitlesrevenue}, {Window_type}='Non-Premium')/
sumIf({selectedtitlesrevenue}, {Window_type}='PVODandPEST')

I would also make sure that you spelled your Window_type strings exactly as they appear in the cells of your table because that can cause issues as well.

Let me know if this works, and if so please mark this post as a solution to help the community.

1 Like
3

That’s it - this should work! Not sure why I didn’t think of it earlier :slight_smile: Thanks Duncan

1 Like