i have a dashboard with two data sources blended and having two calculated fields MTDDelivered and MTDRevenue ,
IF FIRST()==0 THEN
IF FIRST() == 0 THEN
WINDOW_SUM(IFNULL([MTDRevenue], 0), 0, IIF(FIRST()==0, LAST(), 0))
I want to aggregate(DIV) these two fields. while in the calculation it throwing aggregated error how we can resolve it . Please suggest.
can you please attach sample workbook.