Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have two month end date fields in two tables, A_Date from Table A table and B_Date from Table B table and have two measure fields C and D, where dates was matched in both tables and calculate sum and need to find Average
C_M/D,
A_Date having 14 month end dates and B_Date having 12month end dates
first need to calculate sum and need to find total average
I have tried like below
If(A_Date=B_Date, Sum(C_M)/Sum(D),0)
tried one more logic
If(Num(A_Date)=Num(B_Date), Sum(C_M)/Sum(D),0)
I am getting numerator values is correct , the only denominator values getting wrong(D values )
Please help me on this issue, not getting output
please post some sample data and expected output
Please refer this screenshot for your reference