I’m about to reveal my ignorance… Sigh, here goes – on the [Sheet 8] tab, measure values is returning integer values for both ‘checkout complete SUM((IIF’ and ‘offer selected SUM((IIF’.
I see what you're saying though, when I add 'offer selected SUM((IIF' by itself in the tooltip, it is in fact 0. I completely do not understand why.
I have a whole tab, [offer selected] tab, visualizing that measure and it has values in the [Sheet 8] validation tab. I'm spinning.
I can even get it display the [Conversion Rate] in the tooltip on the [Sheet 8] tab, just not on the other tab.
1 of 1 people found this helpful
"offer selected SUM((IIF (copy)" only returns a value for "eventname: "offer selected". But your rows are sum of "offer completed only"
Your calcs seem to be in conflict with each other because they are each basically filtering on different event name.
I'd suggest a little calc clean up (including names ) and see if you can't debug what is happening. If you continue to have trouble please let me know, I can dig in further.
I put it there to get a running sum of events specific to that condition.
The running total was 94, but that changes it to 3,075.
At this point, I’m almost ready to do without the running total, but the end-user wants it.
Thank you. This does get me closer at least.
Thanks so much for your help!!!
I was finally able to generate the result I wanted.
No worries, I am glad to help
Thank you again so much for your help.