Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have 2 different files named 'Previous' and 'Current' where I get my data.
I have defined 1 as Deleted_Flag in my script load editor to help understand where my data comes from.
In the below script, I am aiming to count the SKU Name if it's exist only in the file called 'Current'.
=count(if(aggr(sum(Deleted_Flag), [SKU Name])=1 and [Current or Previous]='Current', [SKU Name]))
It works, but it's affected by user selection. I want to have an exact value in there and it should not be affected any selection. I know we can use {1} as amodifier in set analysis but I couldn't adopt this script to set analysis format.
Could you please advise me how can I avoid any user selection?
Thanks
hi @bsrgln
You can try alternate states, so one part of your formula works with some filters while not affecting other
here you have more Set Analysis options
Hope this helps.
Best,
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😁