I have two calculations in my dashboard first is:-
low = (countd(category)+STR(1))
Low Date = DATEADD('day',[Order Date],(IIF([Low]<=12,[Low],12)))
My first calculation works fine but my second calculation gives me error saying "Dateadd is being called with (string,date,integer)". Can anyone please help me on this. I want my lowdate to be incremented by value returned by IIF condition.
To fix this calculation, I would recommend switching your IIF statement and Date field. Ex. Dateadd('day', (IIF([LOW]<=12,[LOW],12), [Order Date]).
Hope this helps!