I have a Calculated fields like below how can i write this function or below function is good .
Please let me know how can i write these calculated fields
FLOOR([Golden Provider Count]/1000000)*1000000
8 answers
I think GMCDL is also not correct, should be 94,000,000 not 91,000,000
Could you replace the measure by SUM(<Measure>) in all the calculations above? I think that should fix the problem.
Lab might still be zero since you are dividing by a billion and the value is 800 million something.
