Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to be able to use year/quarter/month in a set expression to display a column field.
if it is on Aug-2021, then display $10,000 for instance.
How can I make it work?
If(Year(CreatedDate) = '2021'
and 'Q' & ceil(month(CreatedDate)/3) = 'Q3'
and Month(CreatedDate) = 'Aug', 10000, '')
I solve my own issues, just insert if else statement on load script and use it on my set expression. I would still eager to know how we can use year/quarter/month (pivot table) on a set expression (if anyone has any idea)
I solve my own issues, just insert if else statement on load script and use it on my set expression. I would still eager to know how we can use year/quarter/month (pivot table) on a set expression (if anyone has any idea)