Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to use a function in set analysis without any luck.
The function I'm trying to use is :
=only({<CreatedDate={'=today()'}>}[WeekPeriod])
which returns 201812 (as we're currently in week12 or year 2018)
I'm trying to embed it in this function:
=sum({<[I_Txn-type]={'INV'},[WeekPeriod]={"=only({<CreatedDate={'=today()'}>}[WeekPeriod])"}>}[IL_Net-ext])
but I don't get correct results.
I've tried using single quotes and double quote - the [WeekPeriod]={"=only({<CreatedDate={'=today()'} is just getting ignored all together.
Thanks
Chris
Awesome
Thanks Peter, that's really useful!